Table Formatting

Question

Need to Highlight top 15 values in this.  How we can do this in Basic Table Formatting. Required Output is Customer Name is One Column and 12 months other columns its total columns and row total. And need to highlight only the top 15 values among this.

IMG1.PNG

Qiu · Answer

@anandakrishnan 
This is a very challenging and interesting one, though it is not really Alteryx good at. 😂
In order to use the column rule, we need to bring the Score Value (pick up top 15) and also criteria not to highlight the "Total" row and column.
Another thing is that we can trick Alteryx to utilize the "Dynamic Column" to include the Columns for Month as described in reply below by @SPetrie 
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Highlight-single-cell-in-Render-tool/td-p/929906

[_CurrentFieldName_] != "Customer Name" and [_CurrentFieldName_] != "Total" and [RecordID]!=[Max_RecordID] and [_CurrentField_]>=[ScoreValue]

0917-anandakrishnan.yxzp

dreldrel · Answer

To highlight the top 15 values, first pivot your data with Summarise and Cross Tab to create Customers as rows, months as columns, and a row total. Then transpose the table to rank all cell values, flag the top 15. After that, join those flags back to the pivoted data and use the table tool’s conditional formatting to highlight only the flagged cells

If this helps, please like the post and mark it as the solution. Thank you!

lwolfie · Answer

If you haven't found an answer, I suggest checking out the interative lessons on the reporting tools.

Reporting tools can take a little while to get your head around but there's some great interactive lessons available right here on the community site that break down and explain them all: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Reporting%...