Exclude a feild from the Set Anlysis even if it in chart dimension

[nithin_miryala]

Hi Everyone,

I have question before that Once look at the attached image.

I want the Adjustment% of rolling 13 months.

It is showing me 32.24% as the dimension is Oct 2016. But the result should be as 48.3%.

Is there a way to achieve the total rolling 13 month adjustment % in the Chart i.e ignoring the Dimension.

!

[Anil_Babu_Samineni]

May be try with {1} or exclude the field selector like {<Dimension>} for set operator

[nithin_miryala]

I should be able to filter on other filters. So that solution doesn't apply.

[vishsaggi]

What is the expression you are using in your Adjustment%? Can you share some sample data?

[rwunderlich · Accepted solution]

You will need to add a TOTAL qualifier to ignore the dimension. Can you post your expression?

-Rob