Forum Discussion
Solved
Division on Pivot Table
Hi All,
The below is pivot table and the coulums dervired New & Existing are from the same variable and i need to know the % share of these New & Existing.
Ex:
New/Total (18972/78442)
Existing/Total (59470/78442)
Kindly help!
Thank you this works but i want both numbers and % values in sinlge table. Any turn around?
2 Replies
Easiest way is drag the same fields to the table, right click and whos as percent of row total.
Thank you this works but i want both numbers and % values in sinlge table. Any turn around?
