Creating variable for drill

[Former Member]

Hello, I would like to ask you for your help. Is it possible to create a variable, which containing three different values, that make it possible to filter in drill? It means create a list for different calculations. I have three columns with dates, and I want to create variable including choices "Daysbetween A","Daysbetween B" and "Daysbetween C" and put it in the drill.

Then I want to filter between these choices and each of these choices will count the days between. For example, If I choose "DaysBetween A" in drill, then column shows me days between Date1 and Date 3, but if I choose "DaysBetween C" in drill, column shows me days between Date 2 and Date 3.

[amitrathi239]

i am not sure if you can do with drill filter but with input control you can.check attached link.

Create dummy input control and three different tables.place the show/hide condition which will work with input control.

All steps are there in the wiki link.

https://wiki.scn.sap.com/wiki/display/BOBJ/Creating+a+dynamic+report+using+Input+Controls