Numbers don't stay consistent in pivot table

[wanyunyang]

Hi guys,

I created a pivot table in Qlik sense recording net sales of each sales rep. The first dimension is sales rep, second is customer. When I expand the first dimension (click "+" next to sales rep), net sales numbers change. Why the numbers don't stay consistent?

Thanks in advance!

[isingh30]

Check this -

How to use - Dimensionality()

Thanks.

[wanyunyang]

I unchecked them. I don't want them to show, but when pivot table is closed, the numbers still include those net sales.

[juraj_misina]

OK, then you can try

SUM({<SalesRep*={"*"}, Customer*={"*"}>}Aggr(SUM({<SalesRep*={"*"}, Customer*={"*"}>} NetSales), [OrderNo]))

Although I think you should be perfectly ok with a simple

Sum(NetSales)