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?
In this example, I only want to see the results for Dave Donaldson and Tom Thompson.
What is your expression for YTD Amount here?
May be like this:
Count({<Name = {"=Count([# Of Purchases]) >10 and Expression for YTD Amount >10000"}>} [# Of Purchases])
Replace Expression for YTD Amount with your expression you have used for YTD Amount.
That is part of the issue. I don't know what the expression for YTD Amount should look like...
Please take a look at the attached:
The # of Charges needs to be a Sum and the expression for YTD Amount only works with the small subset of data. There needs to be a check for the dollar amount as well as the total # of charges.
Please see the attached:
None of these solutions seem to fit. Is there a way to use Calculated Dimensions to make this easier?
The issue is that I do not know what the expressions should be. I have 3 fields. Name, Charges, Amount. I have multiple names with multiple charges and amounts. I need an expression that will Sum the vales for Charges and Amounts. I then need to filter the results for charges that are greater than 10 AND where the amounts are greater than $10,000. I don't know if it would be easier to create a calculated dimension that does the check for the condition and suppress null values and then just do the Sum of the charges and amounts in an expression.
Can you let us know the expression that you have used in the excel got YTD Amount..
The issue is that I do not know what the expressions should be. I have 3 fields. Name, Charges, Amount. I have multiple names with multiple charges and amounts. I need an expression that will Sum the vales for Charges and Amounts. I then need to filter the results for charges that are greater than 10 AND where the amounts are greater than $10,000. I don't know if it would be easier to create a calculated dimension that does the check for the condition and suppress null values and then just do the Sum of the charges and amounts in an expression.