Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
My requirement is create calculated dimension based on condition
here in dimension i need show the customers with minimum amount = 500 in my pie chart with thair amount
issue: getting syntax error
check application
Your variable was empty... once I added 500 from variable overview, it seems to be working.
Or you can try like this
sum({<Amount={">=$(=$(vMinimumAmount))"}>}Amount) as expression for Amount >=500
and [Customer Name] as dimension