Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a pivot table with 2 horizontal dimensions and 1 vertical. I have used colour expressions and custom format cell but still have not been able to colour the large cell in top left corner of the table. is there some way to get round this as it really ruins the format of the table.
Thanks
I think by using Color format cell u can change the background color, if u have assigned to the dimenion or fact background color then the custom format wont allow you to change.
first remove all the background color from dimension and facts and use custom format cell to change the color.
Thanks,
But i've tried using, both, and 1 or the other. It is just this cell that causes the issue, and it is only when the 3rd dimension is added.
can you provide an example so that it will be easy to identify the problem..
Post the Demo Application....