This is how it appears pulling Items on Label shelf and then actually removing it from the label.

Hi Glenn,

My understanding is that you want to show the aggregated cost by city, not by item under each city name.

If that is correct, please find attached file (v2018.3).

For the label, make either of these two calculation.

Using LOD    {FIXED [City] : SUM([Cost])}

Using Window Sum    WINDOW_SUM(SUM((Cost))

Then put it into label mark.

If it's LOD, you should set 'Category' as context filter.

If it's Window Sum, you should set calculation by 'item'.

LOD is used for calculation which has different level of detail from what are shown in the viz.

In this case, chart is split by item, but want to show total.

Window_sum is similar and help to calculate total or sub-total of the values on the table with the dimensions you like to consider.

Best regards,

Hideki

My pleasure.

LOD and window sum are beyond the basic a bit, but are really helpful.

Hope you enjoy!

Best regards,

Hideki