I am stuck here with a Pivot Table
if you see the image
Business center and Month are Rows
Rev, Exp are the type of values where USD Amount is sum
The Gran total is the automatic Total that the pivot table add.
What i need is to have another Column to show the % of the Gran Total against Rev Column
in "a" for example, the ne column should show 50% (5/10)
can this be done?
with out modifying the data source, cause is coming from sql
if you see the image
Business center and Month are Rows
Rev, Exp are the type of values where USD Amount is sum
The Gran total is the automatic Total that the pivot table add.
What i need is to have another Column to show the % of the Gran Total against Rev Column
in "a" for example, the ne column should show 50% (5/10)
can this be done?
with out modifying the data source, cause is coming from sql