I have a table, T1, that has a column C1 that is formatted to be a lookup from another table, T2. I set the “display column” in T2 to be the column that I want to “choose from” when choosing the value for C1. T2 has a column C2 that I’m interested in as well.
It would be nice if I could put in a grouping on T1 by C2, per the value I’ve selected in C1. E.g. the grouping I’d potentially set would be C1.C2.
Currently I can only select C1, i.e. the primary columns on T1.
The workaround is to create a column, C3, on my table (T1) and set a formula on it to be C1.C2 and then group by C3. This “bloats” T1 with additional columns that I don’t need to replicate.
Is what I’m trying to do reasonable? Does the suggestion make sense? Does anyone else have this same itch?