K Means Clustering Colour Issue on Scatter Chart

[Jberry]

Hi, I'm hoping someone would be able to help me please. I have a K Means cluster chart on my app and I have it coloured by this expression:

=aggr(KMeans2D(0,[TY Wastage Cost (£)],[TY Reduced Cost (£)], 'zscore')+1, [Area Manager])

The clusters show the Area Manager and when you click into the Area Manager, the Retailer Names of their stores show. However, the colours aren't showing when I click into the Retailer Names. I have tried amending the formula to the below but that doesn't work either:

=aggr(KMeans2D(0,[TY Wastage Cost (£)],[TY Reduced Cost (£)], 'zscore')+1, [Area Manager], [Retailer Name])

Any advice please as to what I'm doing wrong?

Thanks!