Skip to Content

Support Needed: Adding Multiple Totals In One Row Of Data


Relatively new user with hopefully a simple question for this team.

I have an issue with formatting a report and am looking to see if someone might be able to show me where in the system this is, or capable work around. Attached is an image (in excel) of how I am envisioning this to occur. Currently I have a table that shows area on the Y axis and place on the Y. I want to sum the numbers up between a specific set of areas and show their total before moving into the next set of data.

The issue i run into is that the sum function takes everything within that column and tallies it up. Ultimately, I do want that but between the begining row and the terminating row I need to have summations correlating to the areas above it.




capture.png (15.0 kB)
Add a comment
10|10000 characters needed characters exceeded

  • Mahoob,

    Thank you for for the quick response! When i looked at your formula and your recommendation for a break it dawned on me that I have the capability to go one level higher for the areas. Lets call it, regions. I have an excel file linked that I then created variables off.

    Using your break suggestion it looks exactly how I need it to, however when I apply the sum formula to the newly formed breaks I receive the total value for the entire data set, and not the newly formed regions.

    My initial attempt was to utilize an "In" or "with" but I may have been writing it wrong as the value stayed the same or greatly multiplied. Suggestions?

Related questions

1 Answer

  • Best Answer
    Posted on Feb 04, 2019 at 03:43 PM

    Hi Adam,

    Create a variable (formula) to group the Areas called as Area Group, using the below formula, and create a Break on it, that way you can get subtotals for each group and a grand total.

    Area Group

    =If([Area] Inlist ("Area 1";"Area 2";"Area 3")) Then "Area Group 1"
    Elseif([Area] Inlist ("Area 4";"Area 5";"Area 6")) Then "Area Group 2"
    Elseif([Area] Inlist ("Area 7";"Area 8";"Area 9";"Area 10")) Then 'Area Group 3"
    Else "Other Areas"

    But, just so you know, if you start having RunningTotals, then you might want to create separate tables, as needed. Let us know if that helps.

    You can find Web Intelligence Tutorials here


    Mahboob Mohammed

    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.