Restrict calculation in an expression

[Anonymous]

Hi guys,

I just wanted to know if there was any way I could restrict my calculation over a specific dimension. At the time, my calculation is the percentage considering all the elements of the dimension, but I would like to restrict them only to the individual percentage of each element.

For example:

I'm using 2 dimensions, but the calculation should be restricted only to individual elements of the dimension 'org'.

That's my calculation:

And I got this:

the calculation of the percentage is considering all the elements of the dimension, but I would like to restrict them individually.

Like this:

THANK YOU!!

[sunny_talwar]

Try this expression:

Sum(perc)/Sum(TOTAL <Org> perc)

[Anonymous]

Very Good, Sunny, but when I click on the legend to perform a filter, it brings me to filter result all 100%. I would click it and bring me the exact percentage, as it appears before filtering. It's possible?

BEFORE

AFTER

[sunny_talwar · Accepted solution]

May be this:

Sum(perc)/Sum(TOTAL <Org> {<Status>}perc)

or

Sum(perc)/Sum(TOTAL <Org> {1} perc)

[Anonymous]

Thank you!!!

You Always help me!

[sunny_talwar]

Just so you know:

Expression 1) Sum(perc)/Sum(TOTAL <Org> {<Status>}perc)

The denominator will only remain the same based on selection in Status field. Other field selections will still filter the expression

Expression 2) Sum(perc)/Sum(TOTAL <Org> {1} perc)

The denominator will stay the same regardless of any selection you might make.