I made a beast mode as below.
CASE
WHEN SUM(CASE WHEN Region_TWC IN ('NAM','EUROPE','PACIFIC','JAPAN','KOREA','GCA','SEA') AND PO Type IN ('Sample','Demo','SF','M0','M1') AND Meet FOB DL_AR= 'Meet AR DL' THEN Ordered unit END)
>= SUM(DISTINCT PAR in PQ)
THEN SUM(DISTINCT PAR in PQ)
WHEN SUM(CASE WHEN Region_TWC IN ('NAM','EUROPE','PACIFIC','JAPAN','KOREA','GCA','SEA') AND PO Type IN ('Sample','Demo','SF','M0','M1') AND Meet FOB DL_AR= 'Meet AR DL' THEN Ordered unit END)
< SUM(DISTINCT PAR in PQ)
THEN SUM(CASE
WHEN Region_TWC IN ('NAM','EUROPE','PACIFIC','JAPAN','KOREA','GCA','SEA') AND PO Type IN ('Sample','Demo','SF','M0','M1') AND Meet FOB DL_AR= 'Meet AR DL' THEN Ordered unitEND)
END
When run the chart by regions by a specific project in my dataset, the Sum of subtotal of each region isn't equal to Total number.
Ex. Sum of subtotal of each region is 34k.
However, when use project total, the total qty is 42k.
