Create Running total for selected groups

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

The same principles of using where apply but the syntax is slightly different:

=sum([Transaction Value]) Where ([Group] InList (1;2))

[Former Member · Accepted solution]

Hi Mark,

Oh thanks for that  - it worked a treat. I was trying to use if .

many many thanks

Jude

[Former Member · Accepted solution]

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

[sateesh_kumar1]

Hi Judith ,

=Runningsum([Sales])  may solve your purpose

[Former Member]

Hi Durgamadhab,

Thank you for your prompt reply.

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.

[Former Member]

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

[Former Member]

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

=Sum([salesamount]) In Section