Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I unchecked them. I don't want them to show, but when pivot table is closed, the numbers still include those net sales.
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)