Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Need help on conditional format previous week sales

Hi, I want this table to show icons (arrows up, down or equal) if the previous week sales is higher, lower or equal to the sales of the week of that column. Eg: Sales of "boller" in week 43 is higher...
kumar27's avatar
kumar27
Icon for Advocate V rankAdvocate V
5 years ago

Let us make it simple .

Use 2 variables.

One for current week and for that use max .

var 2 will have sum with MAX(column name)-1

 

Now use the calculation in  switch statement.

Thanks