table expression background calculate color tab & cell

[wenkew186]

hi experts,

      i have a problem with when i set the expression background calculate color the tab will with the cell same. can i make the tab color different with cell? my version is 9.0.  pls check the picture and pls help me thanks very much!

kevin.

[bbi_mba_76]

Hi,

If I'm not wrong, in the pivot table the expression header take the background of the first cell.

[wenkew186]

yes sir, it's same with first cell, but have any idea to solved? because the expression backgroup color will change with the data, so the tab will very strange to ever-change. thanks!

[bbi_mba_76]

Maybe adding a total row at the top of the pivot, the header should take the background ot the total.

[wenkew186]

sir,i have try to do it,but the total row color will change with data too, so the tab row backgroup color is not stable yet.

[Sokkorn]

Hi,

Maybe you can try with this post.

Regards,

Sokkorn

[wenkew186]

yes sir, i'm try to follow these operate, but i found the rank of these setting  always after calculate color of expression--backgroup color. so header  backgroup color will change with cell row 1 together.

[#8]

Try with the Visualcues tab

[wenkew186]

how to do it, sir?

[#10]

Hi,

  Go to view Menu of the document choose the design grid and then go to the Table right click on the tab and choose the custom format cell from the properties list give it the background color whichever you want.