Your boss won't have to adjust the Date field -- all he has to do is
select a month from a dropdown list in the Page area.

You set up the grouped Date, as Roger explained, then the field won't
have to be adjusted again.

Andri wrote:
Dear Roger,
Thank you for your advice. But i would like to send the Purchase Report in
Certain Format.
Where i would like to hide the sheet of the pivot table in PROTECTED SHEET
is on, while my boss just click the combo box to select certain month based
on the format i have prepared.

So i have prepared the format of the report, if the boss wish to know by
yearly, so all data will be created for the whole year.
If he would like to know on monthly basis, he just click the month. and the
report will be updated accordingly

For him, adjusting the Data field looks like complicated.

This report just will give a lot of information when the user click the
combo box,
such as how many PO issued, back order, supplier deal for certain month,
Lines Items that purchased.

Thank you.

"Roger Govier" wrote:


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





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html