9 Replies Latest reply on Jun 17, 2015 4:16 AM by Samet İlhan

# groupings of subtotals

Hi there,

is it possible to create a grope of subtotals and how?

For example, I would like to create a group of subtotals from 1 to 5; so I have to bring together the subtotal of "E-Mai sent" and "E-Mail viewed". • ###### 1. Re: groupings of subtotals

Hi Dilyana

You must group members.

• ###### 2. Re: groupings of subtotals

Hey Samet,

thank you!!!

Do you know how can I build a group in this case? I would like to build a groups with numbers

Group A <1

Group B <2

Group C < 3

etc.

• ###### 3. Re: groupings of subtotals

if sum(berencnung)<1 then "A"

elseif sum(berencnung)<2 then "B"

elseif sum(berencnung)<3 then "C"

.

.

.

end

1 of 1 people found this helpful
• ###### 4. Re: groupings of subtotals

I've written the formula:

IF [Summe der Einzelnen ÄW]<0.1 and [Summe der Einzelnen ÄW]>0.5 then "<1"

ELSEIF [Summe der Einzelnen ÄW]>0.5 then [Summe der Einzelnen ÄW]<1 then 1

ELSEIF [Summe der Einzelnen ÄW]>1 then [Summe der Einzelnen ÄW]<2 then 2

END

But my calculation is false. The error appear in the second row by "THEN". The error is " 'END' was expectes as a comlpement to 'IF' fot the sign '0' "

do you have any idea what my mistake is?

• ###### 5. Re: groupings of subtotals

IF [Summe der Einzelnen ÄW]<0.1 and [Summe der Einzelnen ÄW]>0.5 then "<1"

Are you sure that this is true? I think this must be like this

IF [Summe der Einzelnen ÄW]>0.1 and [Summe der Einzelnen ÄW]<0.5 then "<1"

you wrote "then" 2 times.

ELSEIF [Summe der Einzelnen ÄW]>0.5 and [Summe der Einzelnen ÄW]<1 then 1

Every result must be same type. First result a string, second and third result integer. you must write as "1" and "2"

• ###### 6. Re: groupings of subtotals

thanks a lot! It works.

one last question: Do you know how can I select all data from the group "11"? I do it manually and it takes a lot of tim. • ###### 7. Re: groupings of subtotals

You can create set for this or filter that value equal 11.

• ###### 8. Re: groupings of subtotals

it is impossible to crate a filter. (s. Attachment)

how can I create set for this?

• ###### 9. Re: groupings of subtotals

Actually it is possible

1 of 1 people found this helpful