Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to create a pivot table with only one expression but it doesn't show the column header. However if I include another expression, the column header show up for both measures, as soon as I exclude or remove the one of the two measures and only one measure remains active in table, the header row (for measures) goes away. Any idea?
regards,
Salman
This is the normal behaviour of pivot table ...
Is there a way to avoid this? Actually I have a few expressions that are enabled or disabled based on certain conditions. The table layout is best adjusted to show the headers but when there is only one expression left and headers are removed, the layout is messed up.
Add a final column with expression: =' ' and label: make a blank space
resize it
let me know
Causes a think blank column in the end