Drilldown Functionality

I have columns like Plant, Product and Revised Division, I want to find Revised Division based on plant and product like in the plant column if I have 1010 so based on that I can the products in product column and based on those selected plant and product I want to find Revised Division. How can I find it?

Tips and Tricks

Accepted answers

Wesley Mendonca

Hi!

I think you need something like Multi-Conditional ELSEIF statement or some filter to get your results.

I created a example of workflow that might help you:

drilldown functionality.yxzp

All comments

OTrieger

@pgarg
Your post is not written in a very clear way.
You can use filter tool, to remove un needed rows.
You can set it based on many different criteria such as Equals or contains text etc.

If you can elaborate or at some files it will make it easier to understand what you want.

Kenda

@pgarg You could use a summarize tool to find each unique combination of values from your three fields

Wesley Mendonca

Hi!

I think you need something like Multi-Conditional ELSEIF statement or some filter to get your results.

I created a example of workflow that might help you:

drilldown functionality.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703