Is this possible to show in QS pivot table total column ?

[claudialet]

Here is a pivot table. 

Is it possible to show values in a total column for only some of the dimensions ? 

                                Total                  Entity1                Entity2

   LD1:                    10                         5                      5

  LD2:                    8                           4                      4

  LD3:                   6                          3                        3

  LD4:             Not show value        2.1                   2.5

[lalphonso]

Hi Claudia,

You could create a new expression that excludes that Dimension and use it as the Total column,

i.e. sum({<DimensionName -={"LD4"}>}Entity1 + Entity2)

Regards,

LA.