Totals in Pivot Tables

[anthony_kinsell]

Hi,

I have a fairly simple pivot table in place which splits invoices assigned to people into groups as displayed below:

AssignedTo	DaysOpen	0-7	8-14	15-28	over 28	Rejected
		0	0	0	0	10
		0	0	6	10	0
		0	4	2	0	0
		0	1	0	1	0
		2	0	10	22	0
		1	1	0	3	0
		0	1	0	4	0
		0	1	2	0	0
		9	2	2	0	0
		8	8	14	3	0
		0	0	0	3	0
		0	2	0	2	0
		2	0	7	1	0
		7	2	8	28	0
		0	0	3	3	0
		2	0	2	6	0
Total		31	22	56	86	10

My query is as follows: is it possible to also get totals on the right hand side of the pivot table - i.e. for each person.

Thanks

Anthony Kinsella

[vikasmahajan · Accepted solution]

Go to Presenation Tab ->Show Partial Sum

Vikas

[ashfaq_haseeb]

Apart from what vikas suggested. You need to drag 1 dimension to top.

Regards

ASHFAQ

[Anonymous]

Hi

Go to The Presentation and Check and click on the the Show Partial Sum