
Creator
2018-11-29
09:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
chart: dimension in set analysis
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
525 Views
1 Solution
Accepted Solutions

MVP
2018-11-29
10:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
=Sum(Aggr( Sum(percentage) * Sum(DISTINCT TC_Inventory) / (Sum(DISTINCT TOTAL TC_Inventory)) /100 , Facility, Work_Week, Model))
518 Views
1 Reply

MVP
2018-11-29
10:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
=Sum(Aggr( Sum(percentage) * Sum(DISTINCT TC_Inventory) / (Sum(DISTINCT TOTAL TC_Inventory)) /100 , Facility, Work_Week, Model))
519 Views
