disable expression level

[Manni_SM]

Hi All,

@rubenmarin  @Vegar 

i want to disable subtotal in pivot table  from expression level how to do ?

i have 3 dimensions 2 expressions 

Dimensions:  A,B,C

measure1 :  count(distinct id)

measure 2 : sum({<test={'y'}>}  sales+profit)

how to avoid this subtotal in pivot table Qliksense .

[Nagaraju_KCS]

try this,
Since I have 3 dimensions Year, Month and EmpID, so actual data rows have a dimensionality of 3.

[Manni_SM]

Hi @Nagaraju_KCS  still its showing  - symbol 😞

[Qrishna]

Post some sample data and needed output