Skip to Content
avatar image
Former Member

ForEach with two Dimensions

Hi All,

I have a Profit% calculated by Company using a formula as below

[GProfit % CY] In Report ForEach([Query 1].[Company Code] )

But I have an additional need to find the GProfit % for each Company within each Currency, because there are activities happen within each currency for each company?

Thanks,

Arthur.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 21, 2016 at 04:28 PM

    Hi,

    Did you tried? :

    [GProfit % CY] In Report ForEach([Query 1].[Company Code] ;[Query 1].[Currency])

    Or if you want to display as different col, then

    [GProfit % CY] In Report ForEach([Query 1].[Currency] )

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 21, 2016 at 06:16 PM

    Jyothirmayee,

    That solved it.

    Thanks,

    Arthur.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 04, 2017 at 06:56 PM

    Yes. It resolved the issue.

    Add comment
    10|10000 characters needed characters exceeded