on 10-28-2009 5:04 PM
Hi All,
my requrement is i want to display the data betwenn 2 calendar date rage
I mean
I have 25 rows for each day with 4 columns like
StartDate End Date Tcode Count
01/01/09 01/01/09 rsa1 300
01/01/09 01/01/09 rsa2 400
02/01/09 02/01/09 rsa2 400
-
-
-
-
-
-
-
-
-
-
-
-
-
-
I would like select start date in the first calendar and end date in the next calendar
then it suppose to display tcode Vs Count as column chart.
I am getting data from WebI to Live Office and then imorting into the xcelsius.
Thanks
Muvva
As you are getting data from WEBI --> Live Office. I think you can modify the webi query and add 2 prompts i.e. StartDate and EndDate in the Filters panel in Query Designer.
In Excel, have 2 cells one which will hold StartDate that user selects in the Calender and other for EndDate.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.