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