Sum(Total ) with condition

[sohb2015]

Hello All,

I am trying to create an expression:

sum(total{<product={A}>}sales) and it's working.

But I want to put another dimension in the table i.e. country. For example, I want to display my sales data for each country for product A.

So, the expression will be like below:

sum(total{<country,product={A}>}sales) but this does not work.

Can you anyone help me with this.

Thanks

[sunny_talwar]

May be this:

Sum(TOTAL <country> {<product = {'A'}>} sales)

[MayilVahanan]

Hi

You can simply use like this

Dim: Country, Product
Exp: sum({<country=,product={A}>}sales) or sum(total{<product={A}>}sales)