Division on Pivot Table

[Naveeduddinj077]

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!

[vicky_]

Easiest way is drag the same fields to the table, right click and whos as percent of row total.

[Naveeduddinj077 · Accepted solution]

Thank you this works but i want both numbers and % values in sinlge table. Any turn around?