Morning,
This is a picture of a table that I have created:
I have a co-worker who is very insistent that I make this table without showing the columns for FY19 without the columns that are showing no values (Difference and % Difference). In my view the calculations for difference and % difference are just quick table calcs.
I have tried to hide these unpopulated columns but it hides the columns for FY20. I know I could break my view up into individual sheets but I simply was trying to avoid that much work.
So anyone have any ideas how to do this?
Thanks,
Scott
3 respuestas
Hi Scott
see the post See it your way: YoY - there are 3 options to doing YoY the second one will meet the goal
Jim