Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hy ,
Is there any way to change only a selected cell`s color and font? Because when I right click on the specific cell and choose custom format cell the modifies that I will do , it will be made to current expression or all expressions or all expressions and dimensions. But I want to make that change only to selected cell.
You could set the color within an attribute expression - click on the small + sign beside the dimensions/expressions and enter by color something like:
if(count(Dim1 /* are there more dimensions then & Dim2 and so on */) = 1, red(), black()).
- Marcus
I don`t want to collor an expression or a dimmension. I would like to color only the row that has Total for each column of a Pivot Table.
I`ve tried that option too. But It colors all the totals and sub-totals from my pivot table.
Then try to query the dimensionality like:
if(dimensionality() = 1, red(), black())
- Marcus
And where should I write this expression?
Thank you.