I created a pivot table in Qlik sense recording net sales of each sales rep. The first dimension is sales rep, second is customer. The formula is: SUM(Aggr(SUM(NetSales), [OrderNo]))
But my data has some null customers with net sales. When the pivot table closes, the numbers include those net sales. But when it expands (click "+" next to sales rep), the pivot table won't include them. How can I fix this? I don't want my net sales include those null customers when the pivot table closes.
Thanks in advance!