Experts...any suggestion please?
Looks like this behavior is coming from the data. The calculation v.FTE2 which the viz is using is defined as:
IF [Project Name] = 'Total' then [v.fixedFTE] ELSE [FTE] END
Which lead me to look at Project Names for each ARM Resource Type:
Notice that all data for 'Total' is under the 'n/a' ARM Resource Type. Maybe the problem is on the Custom SQL?