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

    Expression not working in pivot table

    siddharth soam



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


      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.