Pivot data, summarize across, labels not available

Hi …

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)?

I see that the expression is a simple addition of 3 columns. You can use Aggregate/Sum grouped by site before pivoting, instead of the expression after aggregation.