Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am using Vizlib Pivot table and I want to assign different colors to the rows in the table.
One row black, one row red, one row black, one row red...
Please help me with your suggestions and approach.
Thanks in advance.
Under Presentation -> Column(Right Cells) you can set color for even and odd rows.
Yes, but this option is only valid for the mesures (right cells).
Is not possible for the left cells (dimensions)
Try:
If(Odd(RowNo(TOTAL)=-1, red(),black())
It's the same, this option only works for the mesures.
Because is a vizlib pivot table, this functions works in a native table or in a native pivot table...
Under Background include the expression.
Hello, thanks for your answer.
But this option only return one color code, is not possible black - red - black - red
I guess you are looking for something like this? You can do that with the Vizlib Finance Report.
Hey @JaimeSAC
Using an expression like =concat(aggr(if(odd(FieldIndex('FieldName',FieldName)),FieldName),FieldName),',') in the dynamic styling for the dimension would help with background color in dimension(Example: Country being the dimension in attached app).
Attached example app.