Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
this is a pivot table. I do not use dimensions and need to delete the "dimension" row, which is in grey, i takes space and i do not need it. Do you know if this is possible?
thanks
Use a straight table instead. Add your expressions, select the option No Totals and on the Presentation tab check the option Horizontal. If you've enabled Always Show Design Menu Items on the Design tab of the User Properties window you can right click the cells with the expression labels and choose Custom Format Cell to change the formatting of those cells.
I'm not sure qv provides this option. If you use a straight table, you do have the optoin to suppress the header row in the presentation tab.
Use a straight table instead. Add your expressions, select the option No Totals and on the Presentation tab check the option Horizontal. If you've enabled Always Show Design Menu Items on the Design tab of the User Properties window you can right click the cells with the expression labels and choose Custom Format Cell to change the formatting of those cells.
thanks a lot , perfect!