Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have four dimensions: revenues, countries, products and customers
By selecting an specific product in a List Box I want the Text Box to show the revenues for an specific country (Germany) and for an specific customer (AAA) for the product selected.
The formula I used in the Edit Expression is:
= sum({<Country={'Germany'}>}{<Customer={'AAA'}>} Revenues)
sum({<Country={'Germany'},Customer={'AAA'}>} Revenues)
sum({<Country={'Germany'},Customer={'AAA'}>} Revenues)
sum({<Country={'Germany'},Customer={'AAA'}>}Revenues)
If you want to make it show irrespective of user selections, you would need to use
sum(1{<Country={'Germany'},Customer={'AAA'}>}Revenues)
-Sundar
excellent ! thanks !