Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Please find in attachment a solution.
You don't need to filter product in dimension part, it's inside the expression.
Regards,
Laura
Hello,
Please find in attachment a solution.
You don't need to filter product in dimension part, it's inside the expression.
Regards,
Laura