Hi there

Suppose I have a pivot table with two columns, date and volume. I want to get the total volume for a date range (ie. a week) with getpivotdata like

=getpivotdata("Volume",$A$1, "Date","1/7/2013 - 1/7/2013 +6")

How can I get it to work?


Thank you.