Set Analysis - stupid question!

[#1]

Hi all

I have 3 different companys and 3 different facts.

I want to show only 1 fact (Actual) in 1 company ... how can I do this?

To show all companies revenue I use this formula:

Num(sum({<Fact.Type = {'Sales'}>}Fact.Net_Rev_EUR), '#''##0.00')

To show only company PTX I tried this, but it gives me the wrong result, as it summarize the total in PTX:

sum({<Fact.Type = {'Sales'}> + <link_table.Company_Desc = {'PTX'}>}Fact.Net_Rev_EUR)

I want that only PTX is displayed...

Thanks for your help

Oliver

[ramoncova06 · Accepted solution]

add the company desc into your set analysis

Num(sum({<Fact.Type = {'Sales'},link_table.Company_Desc = {'PTX'} >}Fact.Net_Rev_EUR), '#''##0.00')

[#3]

Hi Ramon

Thanks for your help!

Cheers

Oliver

[MK_QSL]

sum({$<

          Fact.Type = {'Sales'} ,

          link_table.Company_Desc = {'PTX'}

>}Fact.Net_Rev_EUR)