Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
add the company desc into your set analysis
Num(sum({<Fact.Type = {'Sales'},link_table.Company_Desc = {'PTX'} >}Fact.Net_Rev_EUR), '#''##0.00')
add the company desc into your set analysis
Num(sum({<Fact.Type = {'Sales'},link_table.Company_Desc = {'PTX'} >}Fact.Net_Rev_EUR), '#''##0.00')
Hi Ramon
Thanks for your help!
Cheers
Oliver
sum({$<
Fact.Type = {'Sales'} ,
link_table.Company_Desc = {'PTX'}
>}Fact.Net_Rev_EUR)