Search used field within workflow and multiple filter usage

[kennethli]

I have two questions. 

1. I am handling a large set of data which reuqires me to calculate the cost based on certain ratio. The first step I did is to filter out required cost but it makes the workflow looks complicated because it involves a lot of filter tool. Although the performance is acceptable, is there any better method to do the selection? As the raw data is at very granular level, it could be filtered in a lot of dimensions.

2. Is it possible to search the used field within the workflow? Say I used "field A" in a formula tool, can I do a search to find out where I used the "field A" for calculation (or other process)?

Thanks so much.

[s_pichaipillai · Accepted solution]

Removed all Filters from your workflow and Cross Tabbed the source and Grabed Unique values of your 2nd text Input

see the below .