Build group with AVG as limit value

[#1]

Hello everybody,

i want to build any groups with the Avarage as limit from Group und Avarage +1 as Start for the next Group.

I start with 0 and go with 100 Steps.

For Example:

Values:

1

2

9

5

50

55

66

88

99

100

The AVG from my Example is 42

That means my first Group Start by 1 and End by 42.

The next Group must then be calculated as follows:

Avg(Values from (42+1) + 100)

...

Do you have any idea?

Thanks!!!

[danielrozental]

You can have a dimension with two values (Group 1 and Group 2) and then do

if(Group='Group 1', avg(if(Value<=$(=avg(Value)),Value)), avg(if(Value>$(=avg(Value)),Value)))