Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I wanted to divide the Grand Total divided by Personal Total.The same has to be repeated for the remaining rows also. plz suggest?
I
what do you want to show?
Hi Chanty
I want the Percentage of the Pivot Grand Total(i.e 48261) divide by PERSONAL(i.e 21021) and so on....
the same concept for the remaining PERSONAL,IRA & OTHER Category.
try this
simple way
sum(Value2)/ sum(total Value1)
what is value 2 and value 1 in this case.
I have created the rows by using the calculated field(i.e PERSONAL,IRA,OTHER etc).So I am looking for the division between those calculated fields as I mentioned before.plz suggest
You have been given the answer already:
Divide your expression with the same expression just adding the total identifier
It would be sum(total yourExpression) / sum( total <"Account Type..">yourExpression)
If you want it to only be diveded by the value of personal and be propaged to every single row:
sum(total yourExpression) / sum( total {<"Account Type.."={'Personal'}>}yourExpression)