This content has been marked as final. Show 2 replies
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