I have a report that has row groups for customer MembershipLength (1 year account, 2 year account, etc.) then a sub group of rows for customer Status (active, inactive, etc.) Then I have columns for customer types.
Ultimately I want to add a column that will calcualate the percentage of the subtotal for the corresponding customer type. However, if I break it down and just try to get the sum of the row group for a customer type I can only get both customer types. I only want the MembershipLength customer count for the corresponding customer type.
=Sum(Fields!ZO.Value,"matrix1_MembershipLength") will give me a total for both customer types when I only want it for the corresponding column
I posted the same question on the MSDN forum HERE but haven't got the answer I am looking for yet. However, this might illustrate it better.
without a clearer explination this is all i can figure out.