Share of Product per Category for each month

[jyothish8807]

Hi All,

I need you help with one requirement.

I have a sample data like this:

Product	Cat	Sale	Time		Expected Output
A	AA	10	Jan	33%
B	AA	20	Jan	67%
C	BB	30	Jan	58%
D	BB	22	Jan	42%
A	AA	5	Feb	12%
B	AA	36	Feb	88%
C	BB	12	Feb	18%
D	BB	56	Feb	82%

I want to create a Line chart with "Product" and "Time" as dimension.

Then i would like to show market share of each product over its segment for the particular time period. The expected output is mentioned above.

eg: Product A Sale in Jan = 10, so my requirement will be 10/(10+20)

Same goes for other products  for B =20/30

Br,

KC

[sunny_talwar · Accepted solution]

Try this

=Sum(Sale)/Aggr(NODISTINCT Sum(TOTAL <Cat, Time> Sale), Product, Cat, Time)

[jyothish8807]

Thanks sunny