4 Replies Latest reply on Nov 14, 2017 3:50 AM by Zhouyi Zhang

    When we are using calculation field the auto sort option not available in cross tab

    Naveen T

      we have data like below with sort icon 

      But our client requirement is instead of showing blanks he wants "zero" value ,so i took calculation filed for converting blanks to zeros .

      ZN no of records(calculation filed name) = zn(lookup(sum([Number of Records]), 0)).

      when i add this in the test labels it doesn't show the automatic sort option for the data.

      can you please is there any way to get zeros along with sort option .