Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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,

Tags:
Former Member
replied

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 .

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question