Thursday, February 16, 2012

Calculating Subtotal for Hidden Matrix Column

Hi guys,

I have this matrix as shown below

Column 1 is visible, but Column 2 is hidden, with a width set to 0.

The problem is, I want to have the subtotal of Column 2 shown instead of column 1,

next, I want the subtotal of Column 2 to be divided by a Field called (Fields!Divisor.Value) and this field to be shown. How do I go about doing that?

A small problem I've encountered also is that no matter how I set width of the column to 0, it always changes back to a minute value e.g 0.03125in, is this normal?

Thanks for any help given.

Anyone can help with this? I have searched the forum fervently for answers and tried several methods and am still stuck with it.

No comments:

Post a Comment