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)
|