Sum expression on variations of a dimension

[Dayna]

Hello!

I currently have an expression that uses a max string function, to show the max value for a part on a specific date range, however, this does not take into account different sites. (It only takes the max value for all sites, rather than each site). Obviously, what I need is to calculate the max value for each site and then sum it.

My expressions I currently use, if helpful, are:

if(makeweekdate([BOM Chart - Timescale])-weekstart(today())<=91 AND makeweekdate([BOM Chart - Timescale])-weekstart(today())>0, maxstring([BOM Chart - FCS Sold Qty]))

maxstring({<[BOM Chart - FCS Week Date] = {"<=$(=date(only(today())+91))>=$(=date(only(today())-91))"}>} [BOM Chart - FCS Qty])

firstsortedvalue(DISTINCT aggr(min({<[BOM Chart - Date] = {"<=$(=date(only(today())+91))>=$(=date(only(today())-91))"}>} [BOM Chart - Balance]),[BOM Chart - Timescale],[BOM Chart - AutoNo]),-[BOM Chart - AutoNo])

If you could assist with my issue, it would be greatly appreciated!

Kind Regards,
Dayna

[Dayna]

..