Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Percentage of sales per product and year

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?

Stefan

Labels (2)

• ### Set Analysis

1 Solution

Accepted Solutions
Specialist II

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

5 Replies
Specialist II

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

Contributor III
Author

Thanks Steve!

Contributor III

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

Contributor III
Author

Hi Absihekb,

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

Contributor III

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.

Tags
Community Browser