Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
Please advise whether there are any options to highlight, in colour, only the very top Totals in a pivot table.
I have a table like the one below and tried to solve this issue using the Dimensionality() function. For some reason, my formula does not work.
=If(Dimensionality() = 0,LightGray(), White())
That should work, you have to write same expression in all the Dimensions and Measures for Background color expression
=If(Dimensionality() = 0, RGB(200, 200, 200), White())
It seems to be working - at least to Quarter - but you will probably need to set this customization to each column.
That should work, you have to write same expression in all the Dimensions and Measures for Background color expression
=If(Dimensionality() = 0, RGB(200, 200, 200), White())
@Nagaraju_KCS you are right. Thank you.