Search

Close

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Nice one!

Quick and fun

#249

Here's my solution:

Learned something new through this challenge. Thanks!

I definitely need more practice with tables

Solution

My solution!

Trick to this one was pivoting the data to find the max number, and flagging that record with the Field name... then I could add a column rule to each column in the table to highlight that record in that field if the name matched the Flag value. Cool trick! Always nice to learn some new ways to use formatting in the reporting tools.

Trick to this one was pivoting the data to find the max number, and flagging that record with the Field name... then I could add a column rule to each column in the table to highlight that record in that field if the name matched the Flag value. Cool trick! Always nice to learn some new ways to use formatting in the reporting tools.

Cheers!

NJ