Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to write expression for Qty Share %.
E.g: Brand A Sale qty=58, Overall Sale Qty: 249
Output: 23%
In my pivot table, I have Product as Dimension and column as regions. When i select any brand i get 100%
I want to get Share % if any brand is selected in filter
What is your denominator expression, you will need to ignore selection in Brand field within your denominator expression. For example assuming this is your expression
Sum(Sales)/Sum(TOTAL <Region> Sales)
You would want to change it to this
Sum(Sales)/Sum(TOTAL <Region> {<Brand>} Sales)
It doesn't work.
My requirement is: If I select a product A of brand X from filter, i should get as the sum of qty divided by overall qty of product A
E.g: I select a brand 'B' from filter pane and it has a product 'X' which has qty:59.
Now, I want this 59 to be divided by overall qty of that product 'X'(Removed brand filter)
Can you try this
Sum(Sales)/Sum(TOTAL <Product> {<Brand>} Sales)