Dear Excel Community,
Currently I have a tab that references data from a pivot table via getpivotdata function. How can I modify the getpivotdata formula in a way that it will give me the grand total value up to a certain month.
For example, I would like the grand total from the average price column up till the month of February from whichever start date, however, if I expand the pivot table to include March values (which i need for another sheet), the value derived will be the grand total from the average price column up till the month of March.
Stuck now and some bright ideas needed!
Thank you.
Currently I have a tab that references data from a pivot table via getpivotdata function. How can I modify the getpivotdata formula in a way that it will give me the grand total value up to a certain month.
For example, I would like the grand total from the average price column up till the month of February from whichever start date, however, if I expand the pivot table to include March values (which i need for another sheet), the value derived will be the grand total from the average price column up till the month of March.
Stuck now and some bright ideas needed!
Thank you.