Sunday, February 19, 2012

Accessing sub totals in a matrix

Hi,

How can I access the subtotal cells/values from each of the columns in Matrix and use them for calculations on other places in the report?

Thanks.

Any body?

How can I access the sub-totals of a Matrix as I need to use them in calculations in another place on the report? How can I programatically access the matrix report item's cell or text box values, particularly the sub totals?

Thanks,

|||Does any one know how the sub total field can be accessed in the matrix?|||

Right click on your Column Group Header to acces the Column Subtotal. Same with the Row Group header for the Row Subtotal. I don't think you can access the Subtotal value in other places on the report though.

-Aayush

|||Well, I meant how to access the contents of a subtotal in a running matrix for use in computation in another column/text box. How to access a particular sub total cell value, and say, subtract it from the cell value of another matrix column at corresponding level and display that in a third column.

No comments:

Post a Comment