Drilldown Functionality

[pgarg]

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?

[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: