Sum in dimension

[n1ef5ng1]

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

[SunilChauhan]

try this

if(aggr(sum(TEU),Vessel_Name, Actual_Time_Berth), Discharge_Vessel_Name)

[jyothish8807]

Hi Benn,

If your table is a lose table then I will suggest to try to modify your data model and get a proper data model where all tables have proper link between each other.

For sorting the value you can use firstsortedvalue function.

firstsortedvalue(Vessel_Name,-Volume)

Hope it may help.

Regards

KC