You can do it in both way (fornt/back end side). which side u wanted apply that logic? if u are going to use this measure in many chart object better do it at back end else front end.
as sunny suggestion by using the total and group by class
sum( total <SITE, BRAND> [SALES VALUE])
Fact: LOAD * INLINE [ SITE, BRAND, PRODUCT SUB CATEGORY, SALES QTY, SALES VALUE 100, PAL, CONTOURING, 24, 1943 101, PAL, CONTOURING, 31, 2113.25 102, PAL, CONTOURING, 22, 2026 100, PAL, FOUNDATION, 7, 390 101, PAL, FOUNDATION, 3, 192 102, PAL, FOUNDATION, 5, 380 ]; join (Fact) load SITE, BRAND, sum([SALES VALUE]) as CTS Resident Fact Group by SITE, BRAND;
Sub Total.qvw 155.8 K