Calculating Market Share

[#1]

I have below table in market share I want total of Year. its working fine but value is showing in 1st row of every year.

I have used aggr function =aggr(sum(Sale),Year).

I want to show total of 2012 of every row of 2012 and total of 2013 in every row of 2013 and so on.

Thanks,

Maksood Alam

[simenkg · Accepted solution]

sum(Total <Year> Sale)

[#3]

Thanks Simen

[simenkg]

No problem

The thing you actually asked about is the reason why your expression only gives you the value in the first row. This is because the Aggr function is distinct by default, meaning it will only populate one of the lines. So to specifically answer your question, you can use the function =aggr(NODISTINCT sum(Sale),Year).

However, the reason I replied with the above expression is because its performance is much better and in this case will yield the right answer.

Regards

SKG

[#5]

Cool..

I got your point. Thank you very much Simen for explaining this point. It's really very helpful.