Delete empty dimension row in pivot table

[felcar2013]

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

[#2]

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.

[Gysbert_Wassenaar · Accepted solution]

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.

[felcar2013]

thanks a lot , perfect!