Hi Andri
I don't think you necessarily need to use the Getpivotdata option to achieve
your requirement.
In your Pivot Table, group PO Date by Month.
Then drag the PO Date field to the Page area of the PT report.
Selecting any given month from the dropdown list of months created will show
just the data by Supplier for that month.
--
Regards
Roger Govier
"Andri" wrote in message
...
Dear All,
I have a pivottable about Purchasing Data, contains fields such as
Supplier
Name, PO #, PO Date, Unit Price, Qty and Total Price.
I would like to create a report/list, when a user click (using Combo Box
to
certain Month), so it will create a report Purchasing done in that
specified
month.
The question is how to create this report using GETPIVOTDATA based on that
month with summarized by Supplier name.
Please advice.
Thank you.
Andri
|