edit expression in text box

[danialier]

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)

However this formula does not work and it gives the revenues for Germany but for all customers (not just for AAA customer)

Can you please help ?

Thanks !

dani

[#2 · Accepted solution]

sum({<Country={'Germany'},Customer={'AAA'}>} Revenues)

[sundarakumar]

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

[danialier]

excellent ! thanks !