Skip to main content
Question

Is there any way to cascade in button dropdown for benchmarking

  • July 16, 2022
  • 3 replies
  • 2 views

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​

3 replies

  • July 20, 2022

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!


  • Celonaut
  • August 6, 2022

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


  • Author
  • Level 7
  • August 6, 2022

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