Hi, I've been away from CR for a few years (having been using SQL Report Services instead) and can't remember how to do much, so i'm hoping someone may be able to help me with a specific issue!

I have a crosstab that has two row fields (Customer and Year - the Year will be Current Year and Last Year and possibly the year before last year as well) and a column which we call Type. The Type's are things like Units, Value, Profit etc. I have managed to suppress the Grand Totals, but can't work out how to suppress the Totals being displayed for the Type columns. For example, I'm seeing a total units column for a customer for the last three years - this isn't a useful number for us so we'd like to suppress it. All Suppress Totals options have been selected in the Crosstab Expert window.

Secondly, instead of the Total we'd like to see difference and percentage difference between each subheading for the Current Year and Last Years numbers (i.e. the difference between this year and last years Units, Value, Profit etc). I could do this with extra SQL views but wasn't sure of this can be done in the crosstab instead?

Hopefully this makes sense.

Thanks

Edited by alfiet - 12 Apr 2019 at 1:00am