I have data below mentioned detail
<tbody>
</tbody>
And I insert pivot table from above motioned data that are below
<tbody>
</tbody>
In which date in report filter, collection in values, and region and name in row label
I want I add serial number in peviot report with Name also show in total
Example :
<tbody>
</tbody>
Date | Name | Region | Collection |
21-Sep-15 | Muhammad Ashraf | TTS | 70,000 |
21-Sep-15 | Shahid Nadeem | TTS | 210,000 |
21-Sep-15 | Abdul Wahid | TTS | 170,000 |
21-Sep-15 | Javed Akhter | JNG | 49,160 |
21-Sep-15 | Iftikhar Ahmad | JNG | 100,000 |
21-Sep-15 | Ghulam Murtaza | JNG | 29,371 |
21-Sep-15 | Asif Ali Sabri | SGD | 24,000 |
21-Sep-15 | M.Rafiq Mughal | GRW | 351,900 |
21-Sep-15 | Qaiser Mehmood | GRW | 50,000 |
<tbody>
</tbody>
And I insert pivot table from above motioned data that are below
Date | 21-Sep-15 | |
Row Labels | Name | Sum of Collection |
FSD | Abdul Hafeez | 50,000 |
Asif Mehmood | 300,000 | |
Babar Iqbal | 40,000 | |
Waseem Zafer | 37,600 | |
Zahoor Elahi | 40,000 | |
FSD Total | 467,600 | |
GRW | Adnan Mukhtar | 35,000 |
M.Rafiq Mughal | 351,900 | |
Qaiser Mehmood | 50,000 | |
GRW Total | 436,900 | |
JNG | Ghulam Murtaza | 29,371 |
Iftikhar Ahmad | 100,000 | |
Javed Akhter | 49,160 |
<tbody>
</tbody>
In which date in report filter, collection in values, and region and name in row label
I want I add serial number in peviot report with Name also show in total
Example :
FSD Total 5 | 467,600 | ||
<tbody> </tbody> |
<tbody>
</tbody>