0 Replies Latest reply: Feb 26, 2018 11:36 AM by Wanyun Yang RSS

    Null values make pivot table numbers don't stay consistent

    Wanyun Yang

      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. 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!