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 |