sorting, background colour and dimension expand

[Anonymous]

Hi,

I am having the following in Straight table.

1) I need to do sort  adjust back ground colour for a column and

2) I need an extra column where I can expand to see the rest of columns.

I am attaching required image and app.

please help me out.

[Anonymous]

required help

[Peter_Cammaert]

Straight tables do not allow you to group dimension values or rows. Use a pivot table instead.

To color individual cells, enable Design Grid and right-click on the cell you want to modify. Then select Custom Format Cell... from the menu.

Best,

Peter

[SergeyMak]

Hi John,

Please find attached.

You can use Dual to reorder your columns, but I would recommend to move this calculated dimensions into load script.

I also would not recommend to use this customised tables. You can do it, but you will have too many limitations

Regards,

Sergey