Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to calculate year to year growth, but I've only seen examples using Above() which does not appear to work when years are in columns. This was calculating month to month growth. I am looking for January to January, February to February, and so on. Any ideas?
Try Before() or After() in a pivot table with pivoted dimension
Try Before() or After() in a pivot table with pivoted dimension