Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a pivot table as shown in the image below:
Now what I need to do is exclude certain line items that will be outliers based on a condition from this table. The condition is as follows:
if([Quote Price]*([FX_Rate]/[FX Rate])>=[Cost Estimate]*(1+v_Outlier) or if([Quote Price]*([FX_Rate]/[FX Rate])<=[Cost Estimate]*(1-v_Outlier)
, it is an outlier and needs to be excluded from the table. Here, 'v_outlier' is the variable being controlled by the slider item. I have tried achieving this by adding in these additional if conditions into my existing dimensions in the table but I get a 'Allocated Memory Exceeded' error as the existing if conditions are already complex enough. Then, I tried including these outlier conditions in set analysis as follows:
([Quote Price]*([FX_Rate]/[FX Rate]))={">[Cost Estimate]*(1-$(v_Outlier))<[Cost Estimate]*(1+$(v_Outlier))"}
in my calculated dimensions. But the table now instead stops displaying all the values.
Please help me include these outlier conditions for the table. I'm attaching a sample with the post. Thanks in advance!
Is this what you hoped to get?
Used your above condition as an if statement in all your expressions
Is this what you hoped to get?
Used your above condition as an if statement in all your expressions
That was simple enough. I was under the impression that the 'if' conditions should only be included in the dimensions for it to actually work. I never got the idea to add this to the measures instead. Thanks Sunny and sorry for bothering you with something so silly as this.