Forum Discussion
seakins
10-21-2021Data Storage
Thank you HamzaJ,
I have come across this and used it but was looking to see if the data within the pivot table can be a mixed bag of this year vs last year and a % growth on each section.
If I use what you have said above it keeps all the 2021 data columns on the left and then all the 2020 data columns on the right which makes it a bit of a scrolling left and right game.
With 2020 being a washout, our users are interested in viewing 2021 vs 2019 as it is the most comparable year to go against so also looking for maybe selecting two years (2021 & 2019) to display in the mixed bag of TY vs LY % Incr.