Support Needed: Adding Multiple Totals In One Row Of Data

[astolt12]

All,

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.

Thoughts?

Thanks!

capture.png

[astolt12]

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?

[mhmohammed · Accepted solution]

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
https://blogs.sap.com/2010/08/21/official-product-tutorials-sap-businessobjects-web-intelligence-4x/

Break
https://www.youtube.com/watch?v=JMhAfTHFvMw&feature=youtu.be

Thanks,
Mahboob Mohammed