criteria for Pivot Table

X

xenophon

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

Bob Phillips

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

xenophon

Could you please explain me in details how, with exemple for the date of
25/1/2005 ?

Thanks,
 
B

Bob Phillips

That date would be in A2 in my example.

--

HTH

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

xenophon

Thanks a lot . I've tried it and It works .

Bob Phillips said:
That date would be in A2 in my example.

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
B

Bob Phillips

Great, thanks for letting us know.

--

HTH

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