Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to get the value of the dimension Category='a' and divide for the current dimension category value
id | category | value | % | |||
1 | a | 25 | ||||
2 | b | 25 | ||||
3 | c | 40 | ||||
4 | d | 15 | 1,67 | "=category a / category d" |
Sum({<category={'a'}>} Total value)/Sum(value) should be enough
Thanks, Clever.
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .