How to get Quartes/Age buckets Based on DATE in cross tab report

[Sreeni P]

Hi Gurus

I need solution for the following cross tab report



                                               |              current Quarter            | Previous Quarter|
                                                ----------------------------------------------------
                                               |0-2(days)|3-30|31-90|91-365|365+ |-----do------ |
---------------------------------------------------------------------------------------
Business |Operating Unit                | (amount) (amount)(amount)(amount)
                                                |
                                                |
                                                |
---------------------------------------------------------------------------------------


Here goes the explanation;

1.I need to calculate the 'current Quarter ' and 'previous quarter'  based on the 'Paid date (Date data item)'....how would i get the quarters from 'Paid date'

2. The age buckets are calculated based on the 'paid date' .

3. the (amount) is Invoice amount, and that should be dispaly in the cross tab based on the quarters/age buckets.

If you want any further clarification  i will provide in detail....need bit quickly

Thx