Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Show those employee which Amount is greater than given input box
Hi Vijay,
Please find attached an example.
I hope it helps.
Carlos
Hi,
if you have a chart you could use an expression like if(sum(Amount)>v_InputBox, sum(Amount)) and use the suppress when value is null, or add it as calculated dimension.
Where is attached File???
Just below the text in the comment.
Use below script..
====
Load * Inline
[
Customer, Sales
A, 100
B, 120
C, 200
D, 150
E, 160
];
====
Create a variable vTOTAL and keep it in Input Box
Create a straight table
Dimension
=IF(Aggr(SUM(Sales),Customer)>=$(vTOTAL), Customer)
Tick Suppress When Value is Null
Expression
SUM(Sales)
Now you can change the value of vTOTAL in input box and can see it's effect of Straight Table...