|
-
Oct 25th, 2010, 11:26 AM
#1
Thread Starter
Fanatic Member
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 ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|