rolling computation - What is the way of applying operations between rows in tableau?

Question

I have a sales table and I would like to compute percentage of increase in sales between 2 years. I could create the table which includes the sales happed in 2 years but I couldn't find a way to make operations on them. I would like to apply ((sales in 2018)- (sales in 2017))* 100 / (sales in 2017) operation. Is there any way for applying this operation? sales table for years

Answer 1

For this type of rolling calculations, tableau offers table calculations. I have prepared a similar cross-tab like yours, and follow like the GIF below

Basically you have have to apply a table calculation on aggregated measure i.e. sum(sales) here by right clicking it and selecting % difference.