sum percent in Pivot table
Hi
I must to build a Pivot Table where there are a column is perecent of others 2 columns, when Build PT (pivottable) , It must to do percent from total example
DIFFERENCE is SPENT minus QTD, and PERCENT is DIFFERENCE/QTD
QTD SPENT DIFFERENCE PERCENT
20 10 -10 -50%
40 60 20 +50%
30 45 15 +50%
When I built PT the sum show
90 130 40 50%
I would like show
90 130 40 40/90 ===> 44,44%
Is there some way to do it ?
1 Attachment(s)
Re: sum percent in Pivot table
1 Attachment(s)
Re: sum percent in Pivot table
Thank
But I must show sum of percent like sample in cell E5