Serial Number in Pivot table

Anas_Raza

Board Regular
Joined
Dec 18, 2013
Messages
60
I have data below mentioned detail
DateName RegionCollection
21-Sep-15Muhammad AshrafTTS70,000
21-Sep-15Shahid NadeemTTS210,000
21-Sep-15Abdul WahidTTS170,000
21-Sep-15Javed AkhterJNG49,160
21-Sep-15Iftikhar AhmadJNG100,000
21-Sep-15Ghulam MurtazaJNG29,371
21-Sep-15Asif Ali SabriSGD24,000
21-Sep-15M.Rafiq MughalGRW351,900
21-Sep-15Qaiser MehmoodGRW50,000

<tbody>
</tbody>

And I insert pivot table from above motioned data that are below
Date21-Sep-15
Row LabelsName Sum of Collection
FSDAbdul Hafeez50,000
Asif Mehmood300,000
Babar Iqbal40,000
Waseem Zafer37,600
Zahoor Elahi40,000
FSD Total467,600
GRWAdnan Mukhtar35,000
M.Rafiq Mughal351,900
Qaiser Mehmood50,000
GRW Total436,900
JNGGhulam Murtaza29,371
Iftikhar Ahmad100,000
Javed Akhter49,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 5467,600
Grand Total 181,714,031

<tbody>
</tbody>

<tbody>
</tbody>
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,214,897
Messages
6,122,141
Members
449,066
Latest member
Andyg666

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top