Forum Discussion
Variation between two columns in a Matrix
Hi!
I created a Matrix with the sales information of 2020 and 2021, and I need to show in a third column the variation bewteen both years, like this, I dont know how to do this!, please help me
| Category | 2020 | 2021 | %Variation |
| Deodorants | $254,885 | $386,447 | |
| Footcare | $173,832 | $272,357 |
Congrats,
Diana A
dmarangop You can create a measure like below. and change the format to percentage
Option 1: If you have already have two measures for both 2020 and 2021
Variance = Sum(2021)/Sum(2020)-1
Option 2: if you do not have seperate measure
variance = (calcualte(sum(sales), year='2021') / calcualte(sum(sales), year='2021') ) -1
let me know if it helps you
1 Reply
dmarangop You can create a measure like below. and change the format to percentage
Option 1: If you have already have two measures for both 2020 and 2021
Variance = Sum(2021)/Sum(2020)-1
Option 2: if you do not have seperate measure
variance = (calcualte(sum(sales), year='2021') / calcualte(sum(sales), year='2021') ) -1
let me know if it helps you