4 Replies Latest reply on Feb 18, 2019 11:38 AM by Antti Kaukoranta

# Count products with increasing sales

I've been trying to figure out how to calculate the number of products with increasing sales.

In the attached workbook I have the superstore data, and a table of products, sales by year, and growth in sales by product. I'm trying to make a bar chart showing how many products had increasing, decreasing or constant sales each year.

Any ideas?

• ###### 1. Re: Count products with increasing sales

Hi, Antti

Let me know if you have question.

ZZ

1 of 1 people found this helpful
• ###### 2. Re: Count products with increasing sales

Thanks, this works for me!

• ###### 3. Re: Count products with increasing sales

If I understood correctly, your solution requires making a union of the data with itself. That seems complicated for what I thought would be a simple thing. However, I can't really find any other solutions despite loads of searching.

• ###### 4. Re: Count products with increasing sales

Now I started to become familiar with nested table calculations, and came up with a way to achieve my desired analysis using those. It doesn't require unioning the data with itself and creating a dummy date, like in ZZ's solution, but on the other hand, I use table calculations, which puts limits to how they can be used. Some kind of a simple level of detail method would be optimal - and should be possible, right?

The nested table calc solution is attached.