In Qlik Sense, creating subtotals for specific dimension values in a pivot table (like summing up values A + B and excluding C) directly within the table isn't a built-in feature. However, you can achieve this by using calculated dimensions or measure expressions that specifically include the dimension values you want to sum.
Here's a general approach to create a measure that would only sum the values for A and B:
1. **Create an Inline Table in the Load Script**: You can create an inline mapping table in your load script that assigns a group to dimension values A and B, and another group to C.
```qlik
GroupMapping:
MAPPING LOAD * INLINE [
YourDimension, Group
A, AB
B, AB
C, C
];
LOAD
...
ApplyMap('GroupMapping', YourDimension, 'Other') as Group,
...
```
2. **Use Set Analysis in Your Measure**: Use set analysis in your measure to only sum values where the Group is AB.
```qlik
Sum({<Group={'AB'}>} YourMeasure)
```
3. **Add as a New Measure**: Add this as a new measure in your pivot table to get the subtotal for A and B.
4. **Pivot Table Setup**: Adjust your pivot table to have this new measure alongside your existing measures. You might need to restructure your pivot table to ensure that the dimensions and measures line up correctly to display this subtotal.
Please note that `YourDimension` should be replaced with the actual dimension name, and `YourMeasure` should be replaced with the actual measure field in your data model.
This method requires an understanding of your data model and the way your pivot table is set up. If you need more specific guidance, you would need to provide more details about your data and the current setup of your pivot table.
Remember, Qlik Sense is quite flexible with expressions, and there might be other ways to achieve this, such as complex set analysis expressions or even calculated dimensions. However, the general principle would remain to segment your data either in the load script or within the expression itself.
