Skip to Content
author's profile photo Former Member
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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

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

    Hi Judith ,

    =Runningsum([Sales]) may solve your purpose

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 10:05 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.