Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please write a VBA macro code to create a pivot table for this data set. It has 9 9 6 rows. table [ [

Please write a VBA macro code to create a pivot table for this data set. It has 996 rows.
\table[[Invoice ID ,Branch [, City _,Customer type,grad Gender,grad Product line,grad Unit price ,grad Quantity,grad1,|lax5%|grad,Total,Date,Time,Payment L,gradcogsgrad,gross margin percentage,,gross income |grad|,Rating,grad],[649-29-6775,B,Mandalay,Normal,Male,Fashion accessories,33.52,1,1.676,35.196,2/8/190:00,0.646527778,8 Cash,33.52,4.761904,4762,1.676,,6.7,-2],[189-17-4241,A,Yangon,Normal,Female,Fashion accessories,87.67,2,8.767,184.107,3/10/190:00,0.511805556,6 Credit card,175.34,4.761904,4762,8.767,,7.7,-,]]
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these General Management questions