Link to home
Start Free TrialLog in
Avatar of Marcus Aurelius
Marcus AureliusFlag for United States of America

asked on

SSRS 2008 - How to SUM a FIRST() in a MATRIX?

Experts,

Why is something that should be so easy be so difficult?

Is there a way to SUM a FIRST() in a MATRIX cell? I have a column of data that is displaying the First(Fields!Annual_Spend.Value, "DataSet1"). I simply need to SUM this column of FIRST's...what's the trick..?????

Any ideas?

Thanks
M
ASKER CERTIFIED SOLUTION
Avatar of sammySeltzer
sammySeltzer
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Marcus Aurelius

ASKER

bmendoza - I can explain more, but it's a little complicated. I think if I can simply understand for certain that I will NEVER be able to SUM the FIRST() function, then that will tell me at this point, what I need to know and how to proceed.

I use quite a few reporting products out on the market. (ie. Crystal Reports, Business Objects XI, Microstrategy, etc...) Most of these products are able to handle these types of summaries, but SSRS doesn't seem to have an easy solution...?

Is there perhaps a VARIABLE type of function, that I don't know about that I can store a value of a GROUP and summarize it.., then display the SUM at certain intervals of the report,or certain Group Footers..???

Also,...report needs to be in a Matrix due to the columns need to be dynamic based on a change in Supplier Name.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Had to use First() function and group footer to display the correct amount in the cell, then created another SQL query to provide the SUMs.

Exported to Excel to manually test all summaries in Excel.....

Worked for me,...not the most efficient what to handle though, but all that SSRS could provide....