straight table

[#1]

Hi

can we foramat the straight table as below

Thanks@Regards

Panireddy

[chiru_thota]

you can .

Have you tried View --> Design Grid.

If it is dynamic data uses expression/dimension background color property to write formula with RGB you need

[Gysbert_Wassenaar]

Yes. Click on the + in front of the dimension on the Dimensions tab of the properties window of the chart. Next select Background Color and click the Edit button. Enter an expression to calculate the color. Something like =if(sum(Value)>=0,color(1), color(2)). For the color of the expression column you do pretty much the same thing on the Expressions tab.

[maxgro]

you can set backgroun color of dimensions and expressions

=if(mod(rowno(total),3)=1, red(), green())

[#5]

Thank you

[maxgro]

If you get the answer, please close this discussion by giving Correct and Helpful answers to the posts which are useful for you.  It helps others in finding answers for similar scenarios.

[Joseph_Musekura]

Hi

Massimo formula will make it. I tested it and it works

/jo