Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
MayitaMayoso
Contributor
Contributor

Show only incrementing graphs

Hi all!

I have a graph where I show the sales by year and by product and I want to show only those products which never had a down in its sales in the specified data range.

I have no idea where to start. What do you reccomend me?

1 Reply
miskinmaz
Creator III
Creator III

Hi,
You can use the advance set analysis
For example you can refer to the below expression. The scenario was to find a customer who has not done any sales in past year (new customer)

count({<[Customer Code]-=
{'=count( aggr(count({<[Fiscal Year]={"<$(=max([Fiscal Year]))"}>} distinct [Customer Code]),[Customer Code]))<>0'}>}distinct [Customer Code])