Thanks for the advice about Pivot tables / renaming to those that chipped in. Now pretty much got what I want (will figure out how to dynamically link to a CSV some other time).
But one thing I can't seem to get working is the value filters. Manually selecting entries works, as does slicer, but a 'top ten' or 'greater than' filter in the Size field doesn't seem to have any effect.
Thanks for the advice about Pivot tables / renaming to those that chipped in. Now pretty much got what I want (will figure out how to dynamically link to a CSV some other time).
But one thing I can't seem to get working is the value filters. Manually selecting entries works, as does slicer, but a 'top ten' or 'greater than' filter in the Size field doesn't seem to have any effect.