Calculation in pivot based on the level of detail

[#1]

Hello all, I have the next problem.

I have a pivot with market shares. I have three dims in that pivot. Channel, Category and brand. And one expression called marketshare(in numbers);

This expression looks like this;

Sum({<Manufacturer={WE}>}[NumbersSold]) / Sum([NumbersSold])

When i'm working with this pivot I get the next

This is going fine but now I'm going to show the brands and their the values are 100% for brands that are from 'WE' and 0% for brands that are not fom 'WE'. What I want to see there is the share of the brand in the category. Is this possible in QV? I'm stuck her so anyone can give me a hand? Thanks in advance

[brenner_martina · Accepted solution]

Hi,

the percentage is to be calcutalted by the entered dimension:

Sum({<Manufacturer={WE}>}[NumbersSold]) / Sum(Total <Dimension1, Dimension2,....>[NumbersSold])

Sum({<Manufacturer={WE}>}[NumbersSold]) / Sum(Total <Channel> [NumbersSold])

Sum({<Manufacturer={WE}>}[NumbersSold]) / Sum(Total <Channel, Category> [NumbersSold])

and so on

[#3]

This isn't working when I do this i get odd figures

[#4]

It is working!! Sorry for the first reply, Thnx!