Pivot Table Month and Year Columns - Calculate Variance
Hello - I have a pivot table with one dimension and two columns - month (first level column) and year (second level column). What I'd like to do is calculate the YoY change by month (so for example, YoY change for Jan, YoY change for Feb, etc). So the YoY calculation would have to be subtotal by month.
I've seen various posts on YoY using set analysis, but I haven't been able to get there yet. Any ideas?
