Hide Crosstab node member

[EArumugam]

Hi all,

how to hide the crosstab node member in the report.

for ex.
                                                                year 
                                                 revenue         sales
prodline prodtype prodname
                             total prodname
              total prodtype
totalprodline

in the above example i want hide prod type row, but i want to diaply the prodtype total row in the report. i tried to make it as boxtype but no luck, revenue and sales column not aligned properly.

is there any othere way to hide.

thanks
eas

[PRIT AMRIT]

Select 'Product Line' Column, Property--> Source Type--> Text ( Default it would be 'Member Caption')

Again you got to do a bit of formatting to hide the borders to look nice.

Hope it helps?

Thanks
Prit

[PRIT AMRIT]

Select 'Product Line' Column, Property--> Source Type--> Text ( Default it would be 'Member Caption')

Sorry, select 'Product Type'