I have a trouble to sum intersection and union value.
Red color is attributes for S1, then I need to sum each A and C value,
sum(A) should be 6
sum(C) should be 24
When I select null of F4, I need each value of sum(F1)
This logic is in one sheet of report, and 2 hundred million data in fact qvd.
I've tried to group by this in script, but it is too slow and has linkage issue in report when I select other dimensions
The value maybe calculated in text object and bar chart and so on.
Can anybody give me some suggestions to me?
The requirement is changed...
Add sample here
May be use Aggregation like When should the Aggr() function NOT be used?
You mean, You want to compare row level like S1 having C which has common to all. So, You need to pick 7+8+9 ??
Can you attach your sample?
May be this?