How can we use a value of One Cross Table in other Cross Table in same Report?
I have two Cross Tables in same report by combining with relative position feature.
I have two BEX Queries and one of them is used 1st Cross Table, other one is used 2nd Cross Table.
My aim is to use 2nd Cross Table's Total B's values for 1st Cross Table.
1st Cross Table's objects are below;
[1st Cross Table.Radius]
[1st Cross Table.Month]
[1st Cross Table.Type]
[1st Cross Table.Production]
2nd Cross Table's objects are below;
[2nd Cross Table.Radius]
[2nd Cross Table.Month]
[2nd Cross Table.Type]
[2nd Cross Table.Production]
I used the formula like this. =Sum([2nd Cross Table.Production] Where ([2nd Cross Table.Month] = Last([2nd Cross Table.Month] In Report)))
But value is not coming in 1st Cross Table. I tried forall and foreach function but It has not been a solution. May be, I could not use them.
How can I bring Production B value from 2nd Cross Table to 1st Cross Table? Please help me?