Subtotals in Crosstabs

juabus

I have a crosstab with 6 columns. Now I need column subtotals (like column_1 + column_2). Is there a way to perform such calculations?

Maybe an other approach: is there a way to access measure totals in a crosstab? Must be kind of arrays?

mwilliams

Hi juabus,

You could use the derived measures column to do this. You'd just have to store the last column's value in a variable named after the row dimension so you can access it in the next column dimension. Let me know if you have any questions.