I think it can be accomplished using the methods described in Michael Hesser's excellent post:
It uses the Index function and Modulo function to set the tiles into columns and rows.
( [Index]-1 ) % 7
INT( ( INDEX()-1 ) / 7 )
[Sub-Category] on the Text Shelf, [Category] on the Color Shelf.
Table calculation setting as shown below.
Please see workbook v10.3 attached in the Forum Thread:
285656modulo.twbx 1.2 MB
Thank you very much for the answer. It worked.
Haha! But of course: your work is brilliant,
and that one in particular is clear, comprehensive,
and on top of everything else, a great read.
Thanks for all you do for the community!
I like your work too Michael - I regularly read your blog