While developing a Pivot table , I need to filter my data according to a Group. The Group dimension is classified in several markets(another dimension). The table is having data as below :
Group
Market
Sales
Budget
Group
A
10
-
B
20
-
C
30
-
D
40
-
Non-Group
A
20
-
B
30
-
C
50
-
D
40
-
Total
240
When I add budget here, I get either zero or null values. Basically the budget is not getting classified according to the Group Dimension. How to filter budget (measure) according to the Group category?
