Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Suggestion needed on creating report

Morning all,

I have been asked to create a report which would categorize each lens type according to month. However each lens type would show number of orders according to number of days.

For example

                                           Number of days
                               0 - 1 - 2 - 3 - 4 - 5 -6 - 7 - 8 - 9+

January
    FSV                  12 - 14 -12 - 45 - 65 ....
    FSV-GL
    RXHC
    RXHC-GL
    RX AR Uncut
    RX AR-GL
Feburary
    FSV
    FSV-GL
    RXHC
    RXHC-GL
    RX AR Uncut
    RX AR-GL
March
....

Where

January, feburary are months taken from the dates table, FSV, FSV-GL etc are lens type and 12, 14, 12, 45, 65 are number of orders took for FSV and 0,1,2,3,4... are number of days each order has taken to be shipped.

Now What I have had a thought in mind is to create a report with First Group being Month, then group each Lens type however not sure how to fit each day and order according to lenstype in that particular month.

Any ideas how should I create this type of report?

Regards

Jehanzeb

Former Member
Not what you were looking for? View more on this topic or Ask a question