Skip to Content
avatar image
Former Member

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,

1.jpg (52.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 27, 2015 at 11:25 AM

    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 .


    pastedImage_0.png (12.7 kB)
    pastedImage_1.png (15.0 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 23, 2015 at 06:58 AM

    Hi Experts,

    Is there any comment?

    Best Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 27, 2015 at 10:36 AM

    Hi Victor,

    Formul does not work by unmerging.

    Regardingly,

    Add comment
    10|10000 characters needed characters exceeded