Hi William -
I'll take a swing at this but I'm not 100% sure I understand what you need and why - maybe you can give us a little bit more context?
Anyhow, let's say you have two dimensions: [Customer Name] and [Product Category]. Based on what you're trying to do, you could do one of two things:
- In the Dimensions list, SHIFT-CLICK both fields so they are selected, then right-click either one and choose Create Set. The Create Set dialog will appear and you can give it whatever name you want. Use the SET as a filter.
- Create a new Calculated Field: [Customer Name] + " " + [Product Category] Use this new field in your filter.
Good luck! Let us know if you need more!
Thanks for the reply:
I have 2 fields Modifier1 and Modifier2...these fields can either contain TC,26 or GL. I want to create one filter that will dislapy all rows that either modifier1 or modifier2 have TC in them or 26 or GL:
Row Modifier1 Modifier2
1 26 TC
2 TC GL
3 GL 26
So if able to create one filter on both of these fields and filtered to rows containing 26 then it would grab row 1 and 3.
Hope this helps.
Here you go (see attached)
- Create a parameter which includes potential modifier values
- Create a calculated field which compares Mod1 and Mod2 to the value selected in the parameter. Return True or False based on matching/non-matching
- Use calculated field as a filter
Sample.twbx.zip 12.5 KB
Danka...thanks for the quick response...