Can I pull multple months with GETPIVOTDATA

[steve1040]

Is it possible to get multple months in a getpivotdata this formula

So I want to get data for Jan & Feb

=GETPIVOTDATA("Sales",named_range,"Name","Simon","Month","Jan")

Thanks
Steve

 

[GNB]

You can do it by
=GETPIVOTDATA("Sales",named_range,"Name","Simon","Month","Jan")+GETPIVOTDATA("Sales",named_range,"Name","Simon","Month","Feb")

If you need to do ad hoc months why not set the report up so the months are in your rows and the getpivot formula points to them and do quick sum statements for when you need it

 

[dmadeka]

The one suggested by GNB is probably the easiest.

If you can alter the source data of the pivot you can add another column (quarter / half year / season etc.) which can include multiple months.

You can then use this in the pivot table rather than the month to sum up.

HTH
dmadeka