Lumira Calculations - Percentage of.

[Former Member]

Dear users,

I am trying to build a visualization, creating a calculated measure using the Percentage Of function, as showed in the picture below.

Note the aggregation total number. When I add a top 3 Rank filter, as stated below, the aggregation total changes, and so the Percentage of.

I want to show a market share table, filtering only the top vendors, and their respective share. This way, I cannot add any rank filter.

Is there any way to make this happen?

[varunanand · Accepted solution]

Hi Fabio,

Can you try creating a new measure using individual value/total value in an if-then-else and use it in the cross tab instead of using the Percentage of calculation.

Thank you,

Varun Anand

[Former Member · Accepted solution]

Varun, is your answer implying that Lumira can do different levels of aggregation in a calculated measure?  What would your formula look like?