Summing Value in a Group
-
I have a table with subtotals as well as line item details.
I'm trying to get a sum of the subtotal values by each customer as shown here. I can't figure out how to write the expression to get the highlighted items. I should add that, while in this example the line items do add up to the subtotals, the reality is they may not always and I'm really looking for how to get the sum of the value that's in the group header which could be any numeric value.
Thank you
- This topic was modified 5 years, 1 month ago by callen-557064.
-
is this a SQL or Excel question?
***The first step is always the hardest *******
-
This is an SSRS Report Builder question. The image was taken from Excel to show how the report is structured and what I'm trying to get from it.
-
This is close... hopefully someone can figure out the one part I can't.
I wonder if I can upload .rar files... wish me luck.
-
I tried similar thing with simple POC. Refer the attached screenshot with both "Sub Total" and "Grand Total"
You can refer the below URL for the steps to be followed :
-
Thank you for the response. It looks like your example has the subtotals and grand total based on amounts in the detail row.
In this case, the amount that is being subtotaled is in a group header.
I've attached a document showing the data and a rough report layout.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply