Create a new dimension

[javier_florian]

Hi Everyone,

I have the follow information:

Month          Category          Product          Value

Feb               1                    Emission          $917

Feb               1                    Cancellation     -$25

Feb               2                    Emission          $892

Feb               2                    Cancellation     -$873

So, for business reasons, users need view in a sheet the information filtering Category 1 but in the pivot table Category 1 and Category 2 with Cancellation:

Month          Product          Value

Feb               Emission          $917

Feb               Cancellation     -$25

Feb               2 - Emission    -$873

*Note that sheet has an action filtering Category = 1 when user enable sheet.

I hope be clear with explanation.

Regards,

- Javier

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[javier_florian]

It was so easy... Do you have documentation about work with that expression?

Regards,

- Javier Florián

[Gysbert_Wassenaar]

See here

[javier_florian]

Hi Wassenaar,

I have an additional issue,... the requirement was modified:

Category	Product Group	Product
1	Emission	Emission
1	Cancellation	Cancellation
1	Cancellation	Devolution
2	Emission	Emission
2	Emission	Throwback
2	Cancellation	Cancellation

Sheet filter applies when Category = 1, my graph shows values by Product Group, but I need add to chart values when Product = Throwback

Is possible with set expression?

Thanks in advanced.

[Gysbert_Wassenaar]

If you always want to show Cancellation and Throwback then modify the expression to:

sum({$+<Product={'Cancellation','Throwback'},Category=>}Value)

[javier_florian]

Great, regards Wassenaar!