ForEach with two Dimensions

[Former Member]

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.

[jyothirmayee_s · Accepted solution]

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

[Former Member]

Yes. It resolved the issue.

[Former Member]

Jyothirmayee,

That solved it.

Thanks,

Arthur.