Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i have two tables like
table1:
EID ENAME
1 mahesh
2 rajesh
3 uday
4 pavan
5 raghu
6 rafi
Table2:
EID DEPT SAL
1 HR 10000
2 SE 25000
3 HR 60000
4 SE 30000
5 HR 12900
6 SE 23000
I want to display the top max two salaries from each department
how to write this in set Analysis
Like this?
Hi sunny
Thanks for answer
But i was unable to open QVW file as I am desktop version ..
but i want to display in pivot table
as dept name
HR uday
Raghu
SE Pavan
Rajesh
like this i dont want to use two expression i want to right it in a single expression
May be this:
If(Max(TOTAL <DEPT> SAL, 2) <= SAL, ENAME)
Thanks Sunny its working