I have a set of tables that I am looking to create, but each table will have different columns based on the value of field 'groupname'. We have items with different attributes (color, profile, thickness, width, length, style, etc), but these attributes only apply to some of the groupnames. For instance, groupname A might only have values in color, thickness, and width, but groupname B might only have values in color, profile, style, and groupname C might only have values in thickness, width, and length.
I want to be able to do different tabs/tables for each groupname, so theres not a bunch of blank columns if that groupname doesn't have values in an attribute, but am struggling with how to control the data in this way. Is it a calculated dimension? calculated condition?
So groupname A table should be something like
item color thickness width
Groupname B table should be something like
item color profile style
Groupname C table should be something like
item thickness width length
I know I can build out the dimensions (item, color, thickness, width, etc) any way I want, its the controlling what items show up based upon groupname that I am struggling with. Also want to add that there are no calculations being done here, its basically just a data table returning values.
