Percentage of sales per product and year

[StefanE]

Hello Everyone,

I've got a question where I cannot seem to find a fitting answer in the community:

In a flat table I display year, product (top 3  products plus others (done with dimension limit)) and sales,

It looks a little something like columns A to C in this picture...

What I need would be a column D that calculates the percentage of sales per product and year...

The total sales per year of the indivual products would have to be calculated and divided by the total of all products per that year.

Is this possible?

Thanks in advance for your consideration and kind regards

Stefan

[stevejoyce · Accepted solution]

sum(Sales) / sum(total <Year> Sales)

[StefanE]

Thanks Steve!

[Abhishekb]

How you find out sales per year per product? @StefanE 

[StefanE]

Hi Absihekb, 

if you use a similar kind of table structure, Steve's solution should work. It did for me.

[Abhishekb]

Hi @StefanE ,

Thanks Stefan for answering my question, I got the answer, since I made the mistake in creation of date. Now I figured it out.