View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
via135 via135 is offline
external usenet poster
 
Posts: 94
Default filtering the pivot table..!

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