Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=max({$<[EMPNO]=>} SAL)
i want to display on chart only (maximum salary).
How about
Max ( TOTAL [SAL] )
firstsortedvalue(empno,-sal) for max
firstsortedvalue(empno,sal) for min
Hi Hammad
You may try this-
max({1}Salary)
Here 1 is used as we have to calculate maximum salary from all employees irrespective of currently selected employee and $ is used for current selection.
Regards
Saurabh