I'm creating a pivot table based on cutomer type and item sales for my sales reps.
In my saved search formula I can...
decode({item},'item : subitem1 : subitem2',{Amount},0)
...and it works great.
However, is there a way to get "item" and all sub items without having to type each one? (i.e. I have item with mutlipe subitems, which have mutliple sub items themselves and I want them all in one column of my table)