Suggestion needed on creating report
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.
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 ....
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?