2 Replies Latest reply: Dec 2, 2014 10:23 PM by Jyothish KC RSS

    Sum in dimension

    ben lim

      Hi all,


      I have a list of vessels with the volumes. However, the field that I have selected on my pivot table are fields that are not interlink with the main table. I would want the table to show the list of vessels sorting by the highest volume.

      I was thinking whether does the calculated dimension allows aggr function.

      i.e if(sum(aggr(sum(TEU)),Vessel_Name, Actual_Time_Berth), Discharge_Vessel_Name)


      is there any other solutions