Forum Discussion
Remove totals in matrix table
According to me marix properties->General->Row Totals on/off should work
So I am going to add to this string because there is some confusion. Yes the solution identified turns of ALL TOTALS. But as per the original post - some of us want less sub-totals but still totals. This question is not answered.
There is a post saying that one can right click and select Do Not Summarize - - but that post is incorrect as several have noted - it applies only to the Table visual, not the Matrix visual.
What is happening is that there is a Total line for each Row. The Row fields are defined & showing in the Visual Design Pane at right. To have a less number of Total lines you need to have a less number of Row fields.
In my case I had separate fields for customer name, customer number - - so I created a new calculated field that merged those 2 fields - -so then in the matrix I could have one less Row field - thus one less Total line....
hope this helps someone......
Yes this is crazy. I want to be able to show totals for the columns I choose, not all columns.
I only want to show a total for my $ amounts, the other 'totals' are nonsensical. The same behaviour as the Table visual would be good. And While I'm making suggestions, I'd really like to be able to edit those column headings - what is there is just silly!