Organizing Expressions in a Pivot Table into label groups

deec — Thu, 02 Mar 2017 20:27:17 GMT

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

Re: Organizing Expressions in a Pivot Table into label groups

lironbaram — Thu, 02 Mar 2017 21:22:36 GMT

have a look at the attach example

deec — Tue, 21 Mar 2017 12:09:30 GMT

Thanks, this was very helpful!