Conditional Drill Through with case and when
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.
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
Thanks
Regards
Rendy
The same problem 
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.
Once again, please feel free to raise an Idea for your desired functionality.
regards,
David
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.
Once again, please feel free to raise an Idea for your desired functionality.
regards,
David
Replies have been locked on this page!