Cross tab with highlighting total in the Basic Table

Question

Hi all ,

I've created the cross tab and calculated the count & total. Then I add the Table and would like to highlight the Total column for easier attention of users.

However, I cannot find "Total" in the  "Column Configuration " . Therefore, I cannot create row rule to highlight it. And I would like to show up the "Total" wording under the ccc customer.

Any idea how can the "Total" wording can be added and highlight the row of Total sum?

Thousand of thanks!

cross tab.yxmd

neosui · Answer

Hi @binuacs & @DavidSkaife

Thanks for your both help and it works.

davidskaife · Answer

Hi @neosui

You can do the first part by adding a formula tool (the select tool is to change the size of the Customer field to allow you to enter 'Total'. Once that is done you can create the Row Rule to change the background colour of that row. Please see attached workflow.

Note: i'd remove the null rows from your input as that can create problems, assuming they shouldn't be there.

cross tab.yxmd

binu_acs · Answer

@neosui  You need tp add a formula tool and update the customer field to reflect total

cross tab.yxmd