Can you get max and min values for expression and have dimensions honored, how?

[#1]

There is data that has a few expression calculations.  Dimensions are being used to who data for the axis and the axis changes as you drill into the chart. 

How do I ensure all the data in a dimension level is honored in the layer.  Seems it should be simple, but tried a couple ways and just missing it.

Look at the attached combo charts.

Chart 2 has what is needed at the highest level of week view.  However, if I drill into Char2, it gives a correct calculation for the next dimension level but shows a dimension level 3 lower AND does not spread the bar chart accross the categories at all and this is the biggest issue with this.  

If after you drill in once into Chart2, if you look at Chart1, there is some distribution accross the groups in Chart1, but in Chart 1, unit does not correctly consider both groups below it correctly until I drill into unit further. 

Any ideas?

Thanks,

D

[#2 · Accepted solution]

I had a similar situation where I didn't have all that many dimensions to drill through so I used some if statements to control the expressions a bit better, something like this:

if (GetCurrentField([Group Name]) = 'Wk', Min(total aggr(sum(Base_total), Wk)),

Just replace the field names with your own and add a few more if's

[#3]

I am looking at this and thanks.

Does anyone know why when I drill in one level it the dimensions themselves do not do the separation of the data?

[#4]

Leonard,

Was able to use that concept and get a viable result. 

Thanks,

D