criteria for Pivot Table
 

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)

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)

criteria for Pivot Table
 

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

Thanks,

"Bob Phillips" wrote:

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)

criteria for Pivot Table
 

That date would be in A2 in my example.

--

HTH

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


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

Thanks,

"Bob Phillips" wrote:

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)

criteria for Pivot Table
 

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

"Bob Phillips" wrote:

That date would be in A2 in my example.

--

HTH

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


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

Thanks,

"Bob Phillips" wrote:

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)

criteria for Pivot Table
 

Great, thanks for letting us know.

--

HTH

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


"xenophon" wrote in message
...
Thanks a lot . I've tried it and It works .

"Bob Phillips" wrote:

That date would be in A2 in my example.

--

HTH

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


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

Thanks,

"Bob Phillips" wrote:

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)