Modifier without aggregation

[Anonymous]

Hi,

which syntax must i use, if i want to use a dimension and want to ignore the selection in field country?

Like that, but this syntax is not correct:

({<country= >} products)

regards,

Fritz

[sunny_talwar]

May be this:

Sum({<country = >} YourField)

[sunny_talwar]

Oh I think you can use product as your dimension and use set analysis in your expression to ignore country.

[Anonymous]

Hi,

without sum, count or anything like this.

regards,

Fritz

[sunny_talwar]

Is this for dimension

[Anonymous]

yes

[sunny_talwar]

Try this if you insist on using a dimension:

Aggr(Only({<country = >} products), products)

[Anonymous]

Thanks...

And here?

$(=Pick(Match($(varName),1,2),'products','categories'))

regards,

Fritz

[#9]

You can't use the SET analysis with out aggregation function. Use the AGGR function in the calculated dimension to use SET Analysis.

AGGR( Only({<Country=>}Products) , Products)

The other way, you can use Alternate States as well based on your requirements.

[jagan]

Hi,

It is not suggested to use Calculated dimensions because of performance issues, you can ignore the selections in expression, based on the expression the dimension values are populated.

Dimension: Product

Expression: Sum({<Product=>} SomeMeasureName)

If you have multiple expressions then use this in all the expressions {<Product=>}

Hope this helps you.

Regards,

Jagan.