I have SQL table and it contains millions of records. I just want to get count of every gropy by values dynamically..
This i want using Chart-Straight Table.
For example, let us consider below is my table example.
Material.No Grade
101 A
102 B
103 C
101 C
101 A
110 D
110 A
104 F
103 M
etc..... .....
Final output would be and group by grade. so the count as below
A B C D F M
3 1 2 1 1 1
Note : The output will be always dynamic. some times it may add some more values. so want to get that count also.
pls. guide us how to get the count in Chart - Staright Table. This is important in my module and reply asap.
