I need a cubeset formula that works with powerpivot. This formula needs to be filtered so it is not a normal cubeset formula.
2 Columns: Department, Expense Groupings.
=Cubeset("data model", "[expense groupings].children", "Expense Groupings", 1) will give me all expense groupings under the "Expense Groupings" column.
I want to filter this s...