Hi, I've attached a Packaged Workbook with a Produce Table in it. The table has two filters; "Produce by Group" is setup as an "IF/THEN" calculated field, grouping "Items" into "Dairy", "Fruit", and "Vegetables" categories, while the secondary "Item" filter simply lists values from the "Item" dimension. Both filters will drill-down the data in the table but I would also like the primary "Produce by Group" filter to dynamically update the "Item" filter, so that when a group like "Fruit" is selected, only the items within that group will display in the secondary "Item" filter list. I'm sure this is simple, but so am I. Any info would much appreciated.
Thanks for your time,