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