Hide a value in a Crosstab

[kalvarez]

Hi,
I need to hide a ceratin value in a column of my crosstab but keep the final total

is something like this what i have

               A  B  C     TOTAL
____________________

BLUE     1  2  3        6
RED       2  2  1        5

______________________


And I want this, hiding for example column B but keeping the result,

                A  C     TOTAL
____________________

BLUE     1  3        6
RED       2  1        5

______________________


How can i get this??? can anybody help me please???
sorry for my english.