Hello
I would like to compare sales in march 2018, march 2019, march 2020 and march 2021, each in different rows, and if possible get the % difference between each row, where I get to choose the month.
Something like: Sales % diff in columns and March 2018, March 2019, March 2020, March 2021 in rows.
Is this possible?
@Francisca Grandon
For these, you would need to drag and drop your date to columns, then drag the date to filter and select month(Date), filter march. After that, you can aggregate sales to columns, sales to text.
In this last pill, you right clic and select quick table calculation, % Difference and voilá
Attached a small video how to do it.
If this post resolves the question "Select as Best" or if it assists in resolving the question, please "Upvote". This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego
