Forum Discussion
Summing columns within a matrix
I want to sum 4 columns in my matrix. Rows are states, columns are grouped transaction types into categories "New Business, Renewals, EREs, and Endorsements." Values are premium delta filtered based ...
Are the columns in your matrix calculated columns, or measures ? When you say "I can't use a subtotal" do you mean you don't want the result of your calculation to appear in the bottom line of the matrix ? If you have 4 columns that are measures you should be able to write a new measure that adds those four measures together:
Sub Total = [col1] + [col2] + [col3] + [col4]
My columns are a grouping of transaction type from my dataset, not measures or a calculated column. I don't want to use the column subtotals because I want to add more columns to the matrix, and I don't want those values summed in the subtotal/grandtotal.