Bar chart

[#1]

Hi All,

Thank you all for your help in advance

I am using calculated dimension to exclude some categories from the field and now what I am trying to do it to calculate the percentage on whole rather than on filtered data

Here is the expression used to calculate

Count([TRANSACTION ID])/Count(TOTAL<ZONE> [TRANSACTION ID])

In chart 2 in attached QV I want to calculate the percentage on whole .So Zone A ,Product A2 = 60% and Product A3=  20%.

Can anyone please help me on this

[#2 · Accepted solution]

Hello,

Please find in attachment a solution.

You don't need to filter product in dimension part, it's inside the expression.

Regards,

Laura