Fixing percent

[#1]

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?

[er_mohit]

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

[#3 · Accepted solution]

Only with the Sum(Antall), If you check the 'relative' option, the graph will show the percentages of the shown rows.