Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
I have a table with 3 columns :
Year,Product,Sales
The data is for Sales of various products for the last 3 years.
How can we get list of only those products whose sales have shown a positive trend YOY , say the total sales of those products not only increased from 2015 to 2016 but also from 2016 to 2017.
How to achieve it?
Thanks,
Arvind
Hi Arvind -
Would you be able to share few rows of sample data and the output you expect to see from the sample data you share to better understand what you are trying to get?
Hello Sunny ,
Thanks for the response.
Sample Data :
Load * Inline
[
SYear,Product,Sales
2015,A,10
2016,A,11
2017,A,10.5
2015,B,10
2016,B,11
2017,B,12
2015,C,10
2016,C,9
2017,C,8
];
We want to create two dimensions , one dimension with list of products with increasing sales from 2015 to 2016 and into 2017 i.e. Product B
another dimension with list of products with decreasing sales from 2015 to 2016 and into 2017 i.e. Product C
Thanks,
Arvind
This i have already tried , it shows as Invalid Dimension
See my attachment.