help me with the columns TOTAL in matrix

[ashmitp869]

Hi there,

How can a Total at the end of column of the matrix. I have few rows and two columns in matrix.

I know I can use Columns subTotal on , but my requirement is only to show at end not like this 

Thanks

[RossEdwards]

The options are there in your screenshot.  "Per Column Level".  There is also a similar version in "Row Subtotals" as well.  Turn those opens on and you will see a drop down appear.  Turn the various levels on and off individually and see the results.

[RossEdwards]

In the settings for your matrix visual there is an optionset for "Column subtotals" and one for "Row subtotals".  The matrix should have a separate settings for the grand total version.

In the related sub totals settings, there is a total for "Per Column Level" / "Per Row Level".  Here you can turn off totals at varing levels in your matrix.  Try turning all the lower order ones off.

[ashmitp869]

Sorry, still unable to figure out.

 Can you please provide screenshot ?