Buckets in Report

50 Views

Hi BW Experts,

I have a problem with my Ageing Report.

In MM, we have developed one report i.e, " PO Created After Receipt Of Materials".

Our Report Skeleton.

........................................................................................................

AGEING, NO.Of POs, As a %, Value Of POs, As a%,

........................................................................................................

0-30, 683, 66%, 11,981, 75%

30-45, 225, 22%, 3,058, 19%

45-60, 63, 6%, 590, 4%

60-90, 57, 6%, 260, 2%

.............................................................................................................

Grand Total 1028, 100%, 15,888, 100%

.............................................................................................................

I have got the date difference (By Subtracting 2 Date fields) is nothing but a AGEING. Now i want to put the AGEING in Buckets like 0-30, 30-45, 45-60, 60-90.

But iam unable to put the AGEING in Buckets, (Here AGEING is nothing but a Time Difference between 2 dates ) .

I got the Time Difference (AGEING) by using REPLACEMENT PATH Variables.

Please can anyone help me.

Thanks in advance.

Regards,

Anjali