Bar chart sort by data difference

[#1]

I need to sort by data difference. The objective in this chart is to maintain an equal balance of inventory by item type between my two warehouses.

The first item in the chart should therefore be the item that is the least balanced across my warehouses.

[#2]

I would prefer to do it within the control and not inthe script. This would enable the data to be resorted depending on the user’sfiltering.

[johnw · Accepted solution]

Probably sort by expression, maybe something along these lines sorted descending?

fabs(sum({<Warehouse={'one'}>} Inventory)
    -sum({<Warehouse={'two'}>} Inventory))

[#4]

Thanks allot for your info. its working fine