cancel
Showing results for 
Search instead for 
Did you mean: 

calendar range data

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (0)