filtering pivot table!

  • Thread starter Thread starter via135
  • Start date Start date
V

via135

hi all!

how can i get a custom filtered data in a pivot table? for example i am
having a pivot table having datewise sales data for a month with date as
page filed.

what i want is the data for a given period of dates!

help pl?!

-via135
 
Hi

You cannot group date when the field is used as a page field.
Drag the field to the Row area.
Right click on Field>Group>And Select Month or whatever period you want.
Drag field back to Page area.

Note: In order to grouped dates, there must be no empty cells in the
range, and all dates must be valid Excel dates, not text representations
of date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rolling 12 month date filter for pivot table? 2
Pivot tables 3
Average of Subtotals in Pivot Table 0
grouping dates in a pivot table 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Apply Filter to source of Pivot Table 2
Pivot Table Calculations 2
Calculated Item in Pivot table 1

Back
Top