March 15, 2017 at 10:43 am
Hello,
I have created a SSRS report that displays items based on countries and States and pulls data from two data sets. One data set provides the location information and the other the count of items sold from each state of the country. These data sets pull data from two different SQL servers.
I have used the lookup function to obtain the Items sold and it is working fine.
Now, my issue is that I need to display sub-totals of items sold based on states and further based on countries. I am not able to do it. (tried all i could think of)
When I use the SUM(Functon) on this expression column, I get the sum of all the items, but I need to get the sum of the values from states and countries separately.
Any help in this regard is appreciated
T
March 15, 2017 at 12:15 pm
Add groups for state and country, with subtotals below each group.
March 15, 2017 at 3:31 pm
doug.brown - Wednesday, March 15, 2017 12:15 PMAdd groups for state and country, with subtotals below each group.
Have grouped by state and country but cannot use subtotals as the items sold is an expression
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply