Hi Folks,
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?
Any help would be appreciated.
