Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dimension which is restricted and thereby doesn't show everything.
Current formula:
Sum (Antall)/Sum (TOTAL(Antall))
However this formula yields percentage based upon every number in the dimension. Can this be adjusted so it only calculates from the shown rows?
Only with the Sum(Antall), If you check the 'relative' option, the graph will show the percentages of the shown rows.
try this
Sum (Antall)/Sum (TOTAL Antall)
and in number tab for this expression
fixed to 2 and check on show in % if you want otherwise Uncheck it
Only with the Sum(Antall), If you check the 'relative' option, the graph will show the percentages of the shown rows.