When you add subtotals to a query that uses XLOOKUP calcs, sometimes the subtotal may appear blank on the XLOOKUP field.
To ensure the subtotal gets calculated correctly, you’ll need to ensure all keys are included in the XLOOKUP calculation.
To XLOOKUP with subtotals into the query above, both the lookup_value and lookup_range need to match all dimensions being grouped.
