I have a categorised view, containing three subcategories. In this view, there is a totals column. At the moment, this column produces totals for each category, showing everything. Is there a way that I can change this column so that it will only show the total for one of the categories?
For example, if I have all columns categorised, we have Column 1 total, Column 2 total, Column 3 total. I would like Columns 1 and 2 to be ignored, and only the total for Column 3 to be displayed in the view.
To my knowledge, column totals, when activated, will always display for all categorized columns.
For what you want, you will need to develop a script that analyse a view navigator and builds the report from it, rather than use the view directly.
We did something similar with Excel reporting; basically you create a view navigator which will read the view line by line and column by column, and export the value you want at the place you want in excel, for truly beautiful reports.