In my current case I have 1 table in which I define a type returning 3 different values based on a set of rules. From that table I split into 4 new tables, one per site.
Now, per site I aggregate data by type, and pivot the table.
The issue is, that not all 4 types are relevant for all 4 tables/sites, resulting in error when I try to calculate across on the types.
Question is - Is there a way to calculate columns across without necessarily defining exact columns, which doesn’t involve increasing the number of tables (summarize in new table, merge totals into detail table)?