Subtotal of pivot table depending on row number

[#1]

Hi All,

is it possible to have conditional subtotals based on number of rows?

In the example below the state "California" has two rows, so it's correct to show the subtotal (Total=1704210,80), instead for the state "Colorado" I don't want to show subtotal (Total=448301,50).

Could you help me?

Thanks & Regards,

Simona Arnone

[amit_saini]

Hi,

Check if this will help u:

https://community.qlik.com/message/414232#414232

Thanks,

AS

[#3]

Hi,

I have tried to find a solution in this way (ColumnC), so I wrote the expressions of pivot table.:

I used the NoOfRows() function, but I have no idea how to get in a single column the result of A and C Column.

Thank you for your reply, but I didn't unsterstand how to use the Dimensionality  function in this case.

Thank you so much!