Hi , I have some query
i have a share point list like master based on the list there are two column
1 . function
2 . status(1st,22nd,3rd)
i need function and status wise total count with dashboard .
Please help me urgent ..
Sample dashboard
| Function | 1st | 2nd | 3rd | Total Open | 1st | 2nd | 3rd | Total Closed | Total |
| sample1 | 68 | 2 | 13 | 83 | 236 | 293 | 4158 | 4687 | 4770 |
| sample2 | 28 | 4 | 109 | 141 | 93 | 94 | 721 | 908 | 1049 |
| sample3 | 21 | 4 | 1 | 26 | 58 | 19 | 579 | 656 | 682 |
| sample4 | 38 | 15 | 4 | 57 | 27 | 45 | 431 | 503 | 560 |
| sample5 | 10 | - | 7 | 17 | 11 | 18 | 143 | 172 | 189 |
| sample6 | 2 | 2 | 16 | 20 | 1 | 7 | 124 | 132 | 152 |
| sample7 | 4 | - | 9 | 13 | 25 | 5 | 56 | 86 | 99 |
| sample8 | 4 | - | - | 4 | 9 | - | 37 | 46 | 50 |
| sample9 | - | - | - | 0 | 32 | - | 4 | 36 | 36 |
| sample10 | - | 1 | - | 1 | 5 | 2 | 8 | 15 | 16 |
| sample11 | - | - | - | 0 | 3 | - | 1 | 4 | 4 |
| Total | 175 | 28 | 159 | 362 | 500 | 483 | 6262 | 7245 | 7607 |