Hi,
I need to design a report, in WebI XI r1, for "The qty of product that have been in stock for some range of days (say, since they were brought to the warehouse till today). I have Product dimension, #ofDays in inventory and the qty. Looks simple. But the problem I am facing is that the report should display the #ofDays as a range-
#ofDays Product1 Product2
------- -------- --------
1-30 10 5
31-60 8 5
61-90 4 2
>90 1 0
The # of Days is passed from the universe as some integer value. How do I summarize them into ranges, as above?
I need to design a report, in WebI XI r1, for "The qty of product that have been in stock for some range of days (say, since they were brought to the warehouse till today). I have Product dimension, #ofDays in inventory and the qty. Looks simple. But the problem I am facing is that the report should display the #ofDays as a range-
#ofDays Product1 Product2
------- -------- --------
1-30 10 5
31-60 8 5
61-90 4 2
>90 1 0
The # of Days is passed from the universe as some integer value. How do I summarize them into ranges, as above?