Skip to main content

I want to benchmark/compare based on vendor, country and city. Is there any way I can get that in a single bitton dropdown instead of using 3 different button dropdowns.

I want to achieve this in cascade, like if I select vendor I should see the option to select country and city values.

Thank you​

Hi P.,

 

Yes this should be possible by adding the different columns within one button dropdown and seperate them by ||.

So for instance in your case you would have to write something like this:

TABLE1.VENDOR || ' ' || TABLE1.COUNTRY || ' ' || TABLE1.CITY

I hope this helped!


Hi @Preethi P was the above answer helpful for you? Thank you.


Hi @Preethi P was the above answer helpful for you? Thank you.

Hi, unfortunately No. As the above code will not work as a cascade. It will only concatenate the result of the table. Column


Reply