Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts,
I have a question of how to calculate Shares % of a Pivot table.
I have follwoing Pivot:
The formula here is: Sum({<Distr = >} [Daten])
But how would I have to change the formula in order to achieve following table:
As soon as I use set analysis with "Total" QV calculates the whole period as total and not the total for each month.
Many thanks for any hint!
Best
Frank
Hi,
You put fields to limit the extent of the TOTAL in angle braces after total - so suggest something like Sum({<Distr = >} [Daten])/Sum({<Distr = >}TOTAL <Period> [Daten]).
Cheers,
Chris.
Hi Chris,
Many thanks! That's it.
Sum({<Distr = >} [Daten])/Sum({<Distr = >}TOTAL <YYYY_MM, Quarter, Year> [Daten])
(I have to state <YYYY_MM, Quarter, Year> because I use a 'cyclic group' named "Period", where I switch from "YYYY_MM" to "Quarter" to "Year").
Thanks for your help!!
Best
Frank
Hi,
You put fields to limit the extent of the TOTAL in angle braces after total - so suggest something like Sum({<Distr = >} [Daten])/Sum({<Distr = >}TOTAL <Period> [Daten]).
Cheers,
Chris.
Hi Chris,
Many thanks! That's it.
Sum({<Distr = >} [Daten])/Sum({<Distr = >}TOTAL <YYYY_MM, Quarter, Year> [Daten])
(I have to state <YYYY_MM, Quarter, Year> because I use a 'cyclic group' named "Period", where I switch from "YYYY_MM" to "Quarter" to "Year").
Thanks for your help!!
Best
Frank