Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sum(Sales) / sum(total <Year> Sales)
sum(Sales) / sum(total <Year> Sales)
Thanks Steve!
How you find out sales per year per product? @StefanE
Hi Absihekb,
if you use a similar kind of table structure, Steve's solution should work. It did for me.
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.