Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I would like to compare yeears' sellings for months.
For example i am going to choose January and want to see in this table how was it like in 2021 and 2022.
Also ı would like to compare the values with colors.
I mean if 2022 january> 2021 January make the related column green.
How can i do that comparision analysis?
Best Regards.
Hi @Learnerr,
It would be possible to achieve this with the month and a valuelist for the years as dimensions.
Dimension 1:
=valuelist(2021,2020)
Dimension 2:
=Month
Expression:
if(valuelist(2021,2020)=2021,
sum( {$< Year={2021}>} sales),
if valuelist(2021,2020)=2020,
sum( {$< Year={2020}>} sales)
))
Then right click on the expression column in the table, and click 'Custom format cell'. Click on 'Background color', then 'Calculated' and use the expression:
if( sum( {$< Year={2021}>} sales) > sum( {$< Year={2020}>} sales),green() )
Hope it helps!
Hi @Learnerr,
It would be possible to achieve this with the month and a valuelist for the years as dimensions.
Dimension 1:
=valuelist(2021,2020)
Dimension 2:
=Month
Expression:
if(valuelist(2021,2020)=2021,
sum( {$< Year={2021}>} sales),
if valuelist(2021,2020)=2020,
sum( {$< Year={2020}>} sales)
))
Then right click on the expression column in the table, and click 'Custom format cell'. Click on 'Background color', then 'Calculated' and use the expression:
if( sum( {$< Year={2021}>} sales) > sum( {$< Year={2020}>} sales),green() )
Hope it helps!