Pivot Table: Show Total, Running Total, % Running Total in Single Table

[muhammad susanto]

hi all..

how to manipulate data this below using Pivot Table:

Book1
	A	B	C
1	Date	Product	Units
2	01/10/2021	Coats	622
3	01/10/2021	Shoes	133
4	15/10/2021	Coats	746
5	15/10/2021	Hats	693
6	01/11/2021	Hats	738
7	01/11/2021	Shoes	214
8	15/11/2021	Coats	298
9	15/11/2021	Shoes	120
10	01/12/2021	Coats	139
11	01/12/2021	Hats	980
12	15/12/2021	Hats	718
13	15/12/2021	Shoes	675
14	01/01/2021	Hats	192
15	01/01/2021	Shoes	879
16	15/01/2021	Coats	241
17	15/01/2021	Hats	190
18	15/02/2021	Coats	687
19	15/02/2021	Shoes	374
20	28/02/2021	Hats	179
21	28/02/2021	Shoes	132
22	01/03/2021	Coats	171
23	01/03/2021	Hats	932
24	15/03/2021	Coats	171
25	15/03/2021	Shoes	182
ProductData

i want to show : Total, Running of Total, % Running of Total
please , don't use VBA, Query
someone help

the result in image
.susanto

 

[muhammad susanto]

this my expected result

 

[muhammad susanto]

perhaps, can do it with Calculated Field but i confuse how to use it.

 

[muhammad susanto]

maybe , it more clear

Book1
	I	J	K
3	Sum of Units
4	Date	Product	Running Total…
5	Jan	Coats	241
6		Hats	382
7		Shoes	879
8	Feb	Coats	928
9		Hats	561
10		Shoes	1,385
11	Mar	Coats	1,270
12		Hats	1,493
13		Shoes	1,567
14	Okt	Coats	2,638
15		Hats	2,186
16		Shoes	1,700
Sheet2

how to make running total in..based on date not use Pivot Table but use usually formula

 

[RoryA]

Just add the Units field to the values areas three times and for the second one choose to show it as a running total in the date, then for the third choose to show it as a % running total in the date.

 

[muhammad susanto]

hi Rory, i have do what your suggestion but not show simultance , i want to show together "total", "running total in date", "% running total in date..

 

[RoryA]

That’s what should happen since you have 3 value fields.

 

[muhammad susanto]

ops...sorry Rory, you're right. Now, 3 models have showing.
thank you very much!!!!!

but i'm still confuse how do it use Calculated Field? can do that?

 

[RoryA]

If you have Power Pivot, yes.

 

[muhammad susanto]

hi Rory, for this my case , how to use Power Pivot..
I'm newbie about Power Pivot...Please, give me figure out with my sample case.
I have use it but not much..