Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table with one Dimension, Name and two expressions, # of Purchases and YTD Amount. The result set relies on the expressions working together, meaning, I need to only see the total # of Purchases that are greater than 10 and where the YTD Amount is greater than 10,000. How can I write the two expressions?
Give a try on the below:
Sum({<[# Of Purchases]={"$(=Count([# Of Purchases])>10"},[YTD Amount] = {'>10,000'}>} [# Of Purchases])
If this is not helping, can you please post a small sample.
That is only one expression. Is the YTD Amount expression just a straight forward Sum?
Post your sample data and your expression
The expression I gave you have the both conditions:
It will sum [# Of Purchases] only if count of [# Of Purchases] are greater than 10 and [YTD Amount] >10,000
Is that is what you are looking for ?
No, the table will have 3 columns. Name, # of Purchases, YTD Amount.
I only want to see the # of Purchases that are greater than 10 and the YTD Amount is greater than 10,000.
So, I believe I will need two expressions.
Try as below:
Dimension: Name
Expression1:
Count({<[# Of Purchases]={"$(=Count([# Of Purchases])>10"},[YTD Amount] = {'>10,000'}>} [# Of Purchases])
Expression2:
Sum(YTD Amount)
Hope this helps...
[YTD Amount] is not a field that exists...it is an expression.
Hi Cliff
First expression goes like this
Sum({<[# Of Purchases]={"$(=Count([# Of Purchases])>10"}>} [# Of Purchases])
And second one
Sum({<[YTD Amount] = {'>10,000'}>}[YTD Amount])
Thanks
Karthik
Can you please share a small sample ....