Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Pivot as follows
France
Prod A
Prod B
UK
Prod A
Prod C
Prod E
Italy
Prod A
Prod E
I want to see each Prod Market share vs total Country but do not really get the generic formula to work.
e.g. Can I referer to the Country Dimension dynamically in the calculation e.g. Value/Total Country=P Data or something
Thanks
A
Try something like this: Sum(Value)/Sum(Total <Country> Value)