Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Venkatesh_5990
Contributor III
Contributor III

Show top 2 detailed level of data

I have a summary table like shown below 

Organizations Counts
TCS 5000
CTS 4000
HCL 3000
Wipro 2000

 

Here is the detailed level of data 

Detailed Table 1:

ORG Employee Name Count
TCS A 100
TCS B 90
TCS C 80
TCS D 70
TCS E 60

 

Detailed Table 2:

ORG Employee Name Count
CTS F 40
CTS G 30
CTS H 20
CTS I 10

 

The required output should be Details of top 2 ORGs. One table is TCS and other should be CTS. The output should be change dynamically as the count changes.

Employee Name Count
A 100
B 90
C 80
D 70
E 60

 

Employee Name Count
F 40
G 30
H 20
I 10

 

Labels (1)
0 Replies