chart: dimension in set analysis

[patrou38]

Hello,

in the attached document I've 2 charts.

The first 'With Model',  with a dimension 'Model' in the Stacked chart I have 2 portions (Model1 + Model2) .

In the seconde chart 'Without Model', I removed the 'Model' dimension and I 've in the chart only 1 portion. this is correct but my problem is the value of the Bar. I expected to have the sum of the 2 portions but NO !!!

do you have any Idea of Why and how can I do to have this result ? just the sum on the 2 portion (Model1 + Model2)

thank you for your help.

Cordialy,

Patrick

[sunny_talwar · Accepted solution]

Try this

=Sum(Aggr(
Sum(percentage)
 *
 Sum(DISTINCT TC_Inventory)
/
 (Sum(DISTINCT TOTAL TC_Inventory))	/100
, Facility, Work_Week, Model))