6 Replies Latest reply: Apr 30, 2018 3:29 AM by Jonathan Dienst RSS

    Expression not working in pivot table

    siddharth soam

      Hi,

       

      I am using below mentioned expression as a row in pivot table-

       

      if(GetSelectedCount(H4)=0,restricted_customers,
      if(GetFieldSelections(H4)='Customer Name',if(compare_customers='y',[Customer Name]),
      if(GetFieldSelections(H4)='Customer Group',restricted_customers,restricted_customers

      )))

       

      The expression is working fine but when my H4 is not selected it is returning twice the sum of all the metrics in Totals as well as individual, I want that measures corresponding to restricted customers shall be shown when there is no selection. On the other hand the above expression is working fine in a regular table.