Not well enough explained...
There are too many open questions before someone can give you advice.
But I'll try.
I suppose that all cross tabs are drwan from the same table.
And there are same thoughts like that are summed items should be of the same type, like frequencies, costs,...
And how do you handle overlapping values?
You cannot refer a total sum of a cross tab in another object.
If you cross tab 1 is about sum of turnover by region, your cross tab 2 has sum of turnover by brand.
If no filters apply, both sums are equal and summing them up does not make sense.
It's not clear for me what you want to achieve.
As acordes previously mentioned, you cannot take results from two separate crosstabs and use them in a third crosstab. Visual Analytics does not allow for that.
Rather what you will have to do is create aggregated measures that get you those same results (Counts of 300 and 500, and then Cost of 21k and 43k), and then use those aggregated measures in the crosstab. Without really knowing the data though I cannot say if this will actually be achievable, but this approach will be the only way Visual Analytics will come close to what you need if it can at all.
Alternatively you might be able to achieve this by creating an aggregated datasource with the relevant columns and aggregations. But again without knowing the data, cannot definitively say this will work.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.