Organizing Expressions in a Pivot Table into label groups

[deec]

Requirement:

I need o organize or categorize expressions in a pivot table to make it easier for the user to read a pivot table with a dozen expressions.

Take This:

Turn it into This:

As you can see, I'm using a Pivot Table, not a Straight table.

I can get custom labels into the data model with an inline table but I need to avoid repeating all 4 expressions for both labels.

Playing with conditional enablement, the expression does not seem to want to exist in only one category.

Messing with the expression itself, I can make all values null with an if statement, but no point if the column still shows.

Attaching a simple QVW

[lironbaram · Accepted solution]

hi

have a look at the attach example

[deec]

Thanks, this was very helpful!