filtering the pivot table..!

V

via135

hi

is there any way to filter the pivot table by anyone or more fields..?

for ex for the following 5 fields can i group the date field between
two dates instead of months or qtrs..?

date... code...target...achieved...amount

b'coz..while grouping the date field into qtrs i'am getting the table
only as qtr1,qtr2..etc..whereas i want the exact dates..!!

any hlp pl..?

-via135
 
J

Jim Thomlinson

So you are using the grouping optin built into pivot tables. You are grouping
by quarters, but you issue is that you want to see the individual dates also
in addition to the quarters. Whe you do the grouping the grouping options are
multi select so you can have day, quarter and year selected. Whe you do that
you get a day quarter and year field added to your list. Drag both day and
quarter onto the same report and you are good to go.
 

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

Pivot table 0
Pivot Table 4
Filtering by group in pivot table 0
date filter in a pivot table 1
Slicers and Calculated Items in Pivot Table 2
Pivot table % Difference From (previous) 0
filtering dates in a Pivot Table Report Filter 3
pivot table data 2

Top