drill down

using set

1. create [1. category set] from category
2. create cal. field [2. Cat to Sub-cat] If [1. Category Set] then [Sub-Category] else ” END
3. sales to column; cat and [2. Cat to Sub-cat] to rows
4. create set actions Assign values to set & remove all values from a set