Hi Experts,
My source like below..
| Name | type | typeid |
| aaa | nondeal | GRp |
| bbb | cnf | 1X1 |
| ccc | fv | 2X1 |
| ddd | nondeal | GRP |
| fff | cnf | 1X1 |
| xxx | FD | 2X1 |
| yyy | RD | GRP |
| zzz | FD | GRP |
| eee | RD | 1X1 |
from there we need want rank and count of type id.
but here that count only we need nondeal and cnf,fv this three only need count and remaning as usual display..
I am expacted o/p is ..
| | | type | cnf | FD | FD | fv | nondeal | | RD |
| Name | rank | no of typeid | typeid | 1X1 | 2X1 | GRP | | GRP | | |
| aaa | 1 | 1 | | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| bbb | 1 | 1 | | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| ccc | 1 | 1 | | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
| ddd | 1 | 1 | | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| eee | 2 | 0 | | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| fff | 1 | 1 | | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| xxx | 2 | 0 | | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| yyy | 2 | 0 | | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| zzz | 2 | 0 | | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
How to get Default rank in pivot table
Thanks,
NAni
