Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to Calculate Row-wise Data Totals into a column in SSRS 2008 Matrix Report ? Expand / Collapse
Posted Tuesday, July 23, 2013 1:25 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, October 7, 2015 7:03 AM
Points: 64, Visits: 390
Hi All,

Below is sample report data, In this report I want to show Total Inventory column such that Inventory Avl till date i.e from 1st june to 3rd june for respesctive materials is to come in Total Invetory column i.e. For Item A 2 +3 + 4 = 9, Item B 1 + 5 + 5 = 11 and so on. I have tried every possible ways to achieve this (in SQL script, used SSRS expression, Although I am getting total inventory but getting wrong values) but got stucked every time. I am using sql 2008 and SSRS 2008.

  Post Attachments 
Sample Data.JPG (13 views, 11.03 KB)
Post #1476381
Posted Sunday, July 28, 2013 7:23 PM


Group: General Forum Members
Last Login: Thursday, July 21, 2016 9:25 AM
Points: 176, Visits: 543
Probably the same item is being counted under more than one date of the matrix, but when you count items across all dates, it is being counted only once.

Without knowing the underlying data fields, it is difficult to make a specific recommendation. But my guess is that you will need to find an expression that generates a unique value for each item-plus-date combination and then count that value instead of just counting the items per se.
Post #1478426
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse