Distribution plot: show always 0 as baseline by drilling

[petergassert]

Good morning,

I am trying to focus my distribution plot, that always the 0 is in the middle.
Challange is, that the dimension is a drill down with 2 levels. First includes a formula, to cumulate company codes.

With min and max value this works fine on the first level by using the 

Min(Aggr(Sum(CF_In_CUR_Amount), CF_CompanyPair))*1.1

By selecting a Company Pair and the next level will be opened to a monthly level, i would need to change the grouping to show the 0 as Baseline again. 

Do you have any idea, how to set up the diagramm to always show the 0.

Points: Category Pair
Y-achsis: Drill down (Company Pair , YearMonth)
Measure: Sum(Value)

[petergassert · Accepted solution]

Found the solution myself:

Used following formula in a Minimum and Maximum Variable:
=if(GetPossibleCount(CF_CompanyPair)=1
,Min/Max(Aggr(Sum(CF_In_CUR_Amount),CF_CategoryPair, CF_MonthID))*1.1
,Min/Max(Aggr(Sum(CF_In_CUR_Amount),CF_CategoryPair, CF_CompanyPair))*1.1
)

These variables did I use to check if the Min/Max < or > 0
Min:   = if(num($(vDistPlotMin))<=0 , if(num($(vDistPlotMax))<=0 , num($(vDistPlotMin))  ) , 0)
Max:  = if(num($(vDistPlotMax))<=0 ,0, num($(vDistPlotMax)) )