View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default criteria for Pivot Table

Why not just add another column and calculate the quarter,

=YEAR(A2)&"Q"&INT((MONTH(A2)-1)/3)+1

and add that to the pivot

--

HTH

RP
(remove nothere from the email address if mailing direct)


"xenophon" wrote in message
...
I want to put a criteria like "Between 1/1/2005 And 31/3/2005" in a Pivot
Table without selcting the different dates one by one . I have a data with
Invoice dates and I want to view it by Quarter and not by single date (ex:
25/1/2005)