REALLY enjoyed this challenge. I've been intimidated by the Reporting tools but being forced to have a go proved that it was actually pretty intuitive. I feel like I've opened a door to a previously unexplored part of Alteryx. 🤗
Pretty much identical to the others! Not too many ways you could do this one though. Good to practice the reporting tools.
Spoiler
So to find the highest value in the data set I used the transpose tool to place all the values in one column before using a summarize tool to calculate the max value.
After using append fields to place a max value column onto the original data set with record ID's placed on them it was just a case of using the basic table tool and making use of the column rules to highlight the max value and achieve the required result.
After using append fields to place a max value column onto the original data set with record ID's placed on them it was just a case of using the basic table tool and making use of the column rules to highlight the max value and achieve the required result.
