Hide row in pivot table

[AbhijitBansode]

Hi, i have an requirement of hiding last row of pivot table.

anyone has idea?

[martin59]

Hi,

Why do you want to hide the last row ? Is it a total ?

[AbhijitBansode]

It is not the total..

last row is there  in pivot table with some values..

but i dont want to show this row...

[martin59]

Can you delete thoses datas in your load script or they're useful ?

[AbhijitBansode]

No i cannot delete them..

I purposefully created this row for some other calculation requirement.

I only want to hide this row.

I can make its text color as White by checking if condition,but still blank row appears.

Please help me how can i hide the same or for workaround is it possible to make height of this column as zero using macro.

[martin59]

Is this line has got particular values or something to found it and not the other rows ?

[AbhijitBansode]

Yes,

In this line Product will always have value as 'XX' . so we can easily figure out this line(row) by checking if(Prodcut='XX').

[#8]

I had the same problem and have adjusted the color to the background with one condition.
Have you ever tried this?

Greetings Armin

[martin59]

Right, you have to add the script below on each expression

{<Product-={XX}>}

Like this :

sum({<Product-={XX}>} Sales)

Hope that helps you

[AbhijitBansode]

I can not use above stated expression for sum, because it will filter records of table depending upon that condition.

i dont want to filter records , i only want to hide the row...

i have trieid setting background color of the same.. but still the blank row displays.