Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have an requirement of hiding last row of pivot table.
anyone has idea?
Hi,
Why do you want to hide the last row ? Is it a total ?
It is not the total..
last row is there in pivot table with some values..
but i dont want to show this row...
Can you delete thoses datas in your load script or they're useful ?
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.
Is this line has got particular values or something to found it and not the other rows ?
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').
I had the same problem and have adjusted the color to the background with one condition.
Have you ever tried this?
Greetings Armin
Right, you have to add the script below on each expression
{<Product-={XX}>}
Like this :
sum({<Product-={XX}>} Sales)
Hope that helps you
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.