Former Member

# Create Running total for selected groups

Hi,

I was hoping someone could help me.

I am new to Webi (8 weeks in!) and I am using WEBI 4.0 .

I have created a report which is grouped by the dimension Group [Group 1, Group 2, Group 3 etc]. I have set this to be a section on my report and I have created some totals by these groups. However I now need to create some summaries of these groups. For example add groups 1,2,3,4 together, then 5,6,7 then 5,6,8 etc.

I an sorry if this sounds simple but I just cant see to work out how to do it.

Many thanks and again apologies for my lack of knowledge.

10|10000 characters needed characters exceeded

### Related questions

Former Member
Posted on Jan 08, 2014 at 08:33 AM

Hi

I have 30,000+ products linked to 128 sections. Each section is in a group of which I have 19. A section can only be in one group.

section a= 5

section b= 7

Group 1= 12

section c= 8

section d= 2

Group 2 = 10

section e = 5

section f= 6

Group 3 = 11

I need to now add group 1 and 2 together which will equal 22, then group 2 and 3 which will equal 21, then group 1 and 3 which will equal 23.

In crystal I would do this using 3 running totals and a formula (where [group] in 1,2 etc) but I am unsure how to do this in webi.

Many thanks.

Jude

10|10000 characters needed characters exceeded
• Former Member Former Member

No problem. You're meant to mark mine as the correct answer btw, not yours. ðŸ˜‰

• Posted on Jan 08, 2014 at 04:53 AM

Hi Judith ,

10|10000 characters needed characters exceeded
• Former Member
Posted on Jan 07, 2014 at 07:12 PM

Just create a variable like below and put it in the section for total

=Sum([salesamount]) In Section

10|10000 characters needed characters exceeded
• Former Member
Posted on Jan 07, 2014 at 10:05 PM

I apologise I probably did not explain enough. I have created totals for each section no problem. However what I now need to do is add selected sections together but some sections need to be in more than 1 summary.

for example add sections 1,2,3 together to produce 1 total then add sections 2 and 3 together to create a different total. I assume it is some sort of sum if.....but I am not sure of the syntax.

Sorry for any confusion. Many thanks.

10|10000 characters needed characters exceeded
• Former Member

Could you provide any example with some data and expected output for a better clarity of your requirement.. .?