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.
Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.
Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.
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.