color in label of pivot table

[giakoum]

Hi.

I have a pivot table, and have set a background color calculation for the 1st expression. The expression's label gets the color of the first cell. I cannot use visual cues as I need more than 3 ranges. Any ideas?

Thank you.

[leocvaz]

Hi,

  I had the same problem. I made a workaround that worked in my case.

          - In presentation put the sub total on top

          - in the backgroud color of the expression test the dimensionality (do not color the subtotal)

     The subtotal row works like a barrier for the colored cells.

bye

[giakoum]

Hi Leonardo.

thank you for your reply.

sub total on top did not work for me and dimensionality is not working in pivot tables. But thank you anyway for yor time and sugestion.

BR, Ioannis.