Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
newuser
Creator II
Creator II

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?

 

Thanks

0 Replies