Conditional Drill Through with case and when

Rendy Steffian shared this problem 22 months ago
Resolved

Dear Gurus,

I have 2 question regarding Conditional Drill Through,

1. Can we apply case and when condition? example in the picture bellow i want to have drill though where BU=others and BI-Category =Others.


/cVO2vefeAAAAIUlEQVSLb8ku46wLLNb5YJwV7zgECF4Hr4IvglMtMe7+P2dBPQON5eH3AAAAAElFTkSuQmCCAA==


Question number 2:

Can we apply 2 drill though scenario in the same hyperlink field.

example picture in the bellow if category all -> drill through to report A, else drill through to report B

/ZAA==

Thanks

Regards

Rendy

Comments (1)

photo
1

Hi Rendy,

1.

No, currently it is only possible to set a condition for one of the Join fields. In your example you can only either create a condition for BU = others, or instead you could create a condition for BI-Category = Others, but you cannot set a condition for both fields together.

However, it seems to be a very good idea, so please feel free to raise an Idea for it in this Yellowfin Community.

As a workaround I guess you could accomplish the same thing by doing it over 2 levels, i.e. have a 1st level conditional drill through where BU = others, and then that would drill through to a child report that would then offer a conditional drill through to a 2nd level where BI-Category = Others.


2.

No, it is not currently possible to apply 2 drill throughs to the same hyperlink field such that the drill through automatically selects which child report it will drill through to depending on the value of the Join field.

However, it is possible to have 2 drill throughs on the same hyperlink field, but the difference from your scenario is that the user must manually select which child report he wants.

/0DMnqxo+tHyIepZNQ1ivk1tBqIO0d2jDeg51AC6hf8PJ3KzUBbtaXAAAAAASUVORK5CYIIA

Once again, please feel free to raise an Idea for your desired functionality.

regards,

David

photo
1

Dear Dave,


Thanks for the reply. noted for this issue.

i will raise this idea


Thanks

Regards

Rendy

photo
1

OK, I think it's a good one!

photo