Click here to Skip to main content
15,891,864 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have designed matrix table in ssrs, all items are displayed in columns and counts are displayed in rows.. I need sum of all items in final row i.e, footer.

My problem is:
1. sum of all items values displayed in all columns.
2. sum of all items values displayed in every groups. but i need only in footer.

I need solution for this.

I need sum of every items in footer,

Actual Table Values:
Item Name Qty
Item-001 3
Item-002 5
Item-001 2
Item-002 1

Matrix Table:
Date - Item-001 - Item-002
24-02-16 - 3 - 5
25-02-16 - 2 - 1

My Problem is Every date footer shows: 11 in all footers

What I have tried:

I just tried: Expression for that count textbox:

=Sum(Fields!MatQty.Value)
Posted
Updated 22-Feb-16 20:28pm
v4

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900