5 Replies Latest reply on Jun 23, 2016 7:57 AM by Joe Oppelt

Find Products which are only increasing

Hi,

I have a requirement to only find top products which increase over time. All the other accounts should be filtered out.

Likewise, I have to find the bottom products which decrease every single period of time.

Also, find products which have the biggest drop from initial date to the most recent date. And products which have the biggest gain from initial date to recent date.

For example in this screenshot
1. I only want furniture to remain in the view- that is the only account which is increasing every single time(There is no product which loses every single time, but you get the gist.

2. In the same screenshot, the biggest gain is again furnitues. And the biggest drop is for Office suuplies .

How to accomplish this? Thanks

• 1. Re: Find Products which are only increasing

See attached.

I created two calcs.  One looks at the prior value and sets 1 or 0 if it has increased. This is how you know if it grows.

I also created [Index] so you can see how to tell where you are in your calcs.  (So, for instance, the look-back-a-cell calc could actually say, if index = 1 then 1 else if LOOKUP(etc...) ).

If you get all 1s in your row, the sales have only continued to increase and you want to see that one.  These are some tools you can use to get what you need.

• 2. Re: Find Products which are only increasing

So I added that extra step to Calculation1.  (We want all 1s, so force the first cell to 1 -- otherwise it'll always be zero because there is no previous value to compare.)

Then I created a table calc to check all the [Calculation1] values in the row.  If any are zero, the value dropped from the previous, and we don't want to see it.  Put that on the filter shelf (see sheet 2) and just get rows that have all 1s.

See new attached.

• 3. Re: Find Products which are only increasing

Thanks Joe. That helped a lot and it's a good start.

One another question. I have data in my data set in an incremental format.

For examples if the sales values in january is 100, , february is 200, March is 300, the actual february is 200-100. march is 300-200. I want to find the actual values every month, I know I can write a table calcualtion to achieve this. Is there anyway we can do it without a table calculation? Sometimes with table calculation, it gives me weird results.

I have mocked up the data in the attached workbook

• 4. Re: Find Products which are only increasing

Laze, there is not another way to do it in Tableau. You can do in your data.

I used table calculation in your sample and it works.

Maybe you need to customize your table calculation from December to January

• 5. Re: Find Products which are only increasing

Ditto