Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Sum({<country = >} YourField)
Oh I think you can use product as your dimension and use set analysis in your expression to ignore country.
Hi,
without sum, count or anything like this.
regards,
Fritz
Is this for dimension
yes
Try this if you insist on using a dimension:
Aggr(Only({<country = >} products), products)
Thanks...
And here?
$(=Pick(Match($(varName),1,2),'products','categories'))
regards,
Fritz
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.
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.