Remove First Row From Pivot Table

[#1]

Hi,

I have a pivot table without any dimensions, and with a couple of expressions.

I want to remove the first row, where the dimensions labels would have been.

I know that in a straight table I can hide it, but for my needs, it must be a pivot table.

I've attached a .qvw with a simple example.

Thanks!

Edit: clarification: I do not wish to remove the row 'count of Index', I want to remove the one above it, where the dimensions labels would have been.

[sorrakis01]

Hi,

In conditional of the expresion write this count(index)>0

Regards

[Anonymous]

Jordi,

You can use 'if' in expression or in conditional to hide the expression.

Morandi

[sorrakis01]

Hi,

i knowed I didn't create the discussion

Regards,

[#5]

Hi,

Sorry, I probably didn't explain right.

I want to remove the first row (the gray one).

I changed the image and added an arrow to emphasize which row i want to hide.

Thanks!

[simondachstr]

Not really what you were looking for, but a good workaround if you're fine with removing the caption.

[sorrakis01]

Hi,

I think You can't do it in a pivot use a straight.

Regards,

[#8]

Yes, i'm fine without the caption, but how did you do it?

I presume you changed the 'Costume format cell' but I cant replicate the same look

[simondachstr · Accepted solution]

Set everything to transparent (also in the properties page), remove borders etc. etc.

[Greg_Williams]

Few ideas:

1 - Consider removing Aggregation / Total in Properties > Expressions tab

2 - Reduce font size to 1 > make everything white > custom format cells needs to be turned on for this to be available in User Preferences > Design.

Regards,

Greg