Create a calculated dimension :
=if( aggr( sum(Actual) , Prod) >1.5 * aggr( sum(Estimate) , Prod) ,Prod , Null())
Where Prod is your dimension.
and check "suppress when value is nulll
You have to use aggr if you have multiple values for each prod item.
If you have only one row for each prod you can of course create dimension
=if( Actual >1.5 *Estimate ,Prod , Null())
Thanks for your reply. I created calculated dimension as you mention but getting "error n calculation" message.
The formula I used is as below:
=if( $(vActualCost) > (1.5 * $(vEstimatedCost)) ,[Invoice No] , Null())
where vActualCost and vEstimatedCost are the variables.
Can you please suggest whats wrong?
As the attachment file was developed in licensed copy, you wouldnt be able to open it in personal edition.
Below is the script part.
LOAD * INLINE [
Prod, Actual, Est
A, 234, 100
B, 50, 45
C, 200, 120
In the UI layout,add a straight table as below,
Calculated Dimension : =if( $(vActualCost) > (1.5 * $(vEstimatedCost)) ,Prod , Null())
Also attached the screenshot of Variable Overview.
variable.JPG 23.1 K