How can we use a value of One Cross Table in other Cross Table in same Report?

[Former Member]

Hi,

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?

Best Regards,

[sateesh_kumar1 · Accepted solution]

Hi Tarumar ,

Merge Type ,Radius  and Month

Use below cross tab structure

=Last () function works based on alphabets , we need to use =max(todate([Month];"MMMM")) in report to have maximum month .

[Former Member · Accepted solution]

Hi Sateesh,

Thank you very much.

Your formula is working.

Thanks a lot.

Best Regards,

[Former Member]

Hi Victor,

Formul does not work by unmerging.

Regardingly,

[Former Member]

Hi Experts,

Is there any comment?

Best Regards,

[Former Member]

I would not use forEach or forAll because they take the current context into account which is crosstable 1. Use In with explicit inclusion of dimensions.

Best regards

[Former Member]

Hi Victor,

I tried to used below formula but I am not still getting the value of [2nd Cross Table.Production] in 1.st cross table.

I have merged the common dimension values.

=Sum([2nd Cross Table.Production]Where ([Month] = Last([Month])In Report)In([Month];[Type];[Radius))

Please help me.

Best Regards,

[Former Member]

Hi,

Is there any solution to this question, please?

Regardingly,

[Former Member]

Does the Formula work if you unmerge?

[Former Member]

Hi Victor,

Formula does not work at unmerged state.

Regardingly,