September 24, 2008 at 1:14 pm
Is it possible to create calculated fields on a Matrix report to get the totals of each rows and columns? I am having to add the logic into SQL to get these totals, but there must be a way to do this via SRS?
September 24, 2008 at 6:57 pm
Hi
If you do a bit of right clicking on the columns and rows you want to total you will soon find the answer to your question...
September 24, 2008 at 7:46 pm
awesome!
September 25, 2008 at 7:53 am
More so than just doing a subtotal, how can we add additional calculated fields to the right of the row? For example what if I want MIN, MAX, or AVG instead of totaling up the numbers?
September 25, 2008 at 9:34 am
I am pulling my hair out on this one, i agree getting subtotal is as simple as right clicking, but what about average? What about Min? What about Max? What about any aggregate function? Does the matrix control not allow for adding an additional column to the right for other calculations? :crying:
April 17, 2017 at 5:25 am
Click on the dataset name in the 'Repoprt Data' tab
Right click
Add Calculated Field
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply