Skip to Content
0

Creating variable for drill

Mar 12 at 04:15 PM

24

avatar image
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.

1.jpg (108.8 kB)
2.jpg (67.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Mar 13 at 11:47 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded