Skip to Content

Creating variable for drill

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.

1.jpg (108.8 kB)
2.jpg (67.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 13 at 11:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded