Share %

[iswarya]

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

[sunny_talwar]

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)

[iswarya]

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

[iswarya]

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)

[sunny_talwar]

Can you try this

Sum(Sales)/Sum(TOTAL <Product> {<Brand>} Sales)