Percentages in a pivot table

S

sknight22

Board Regular
Joined
Feb 16, 2016
Messages
75
Hello,

I have a booking slot system with slot times 0600 - 2000. there are 53 in total and I want to copy the data into an excel file and have a pivot show the percentage of slots filled. Each slot filled with have a 5 digit reference number entered and empty slots will just be blank.

Is there a way the pivot can work this out? Im struggling to get it right?

Many thanks

Stephen
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
You must log in or register to reply here.

Similar threads

C
  • Question Question
Confused over pivot table calculations :-(
Replies
1
Views
624
number kruncher
N
A
  • Question Question
Calculated Pivot Table Field
Replies
1
Views
910
RoryA
RoryA
M
  • Question Question
Calculating Percentage between two columns
Replies
0
Views
1K
Mr Steve Cox
M
K
  • Question Question
Pivot Table
Replies
0
Views
242
KillerOfGiants
K
M
  • Question Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
3K
Alex Blakenburg
A

Forum statistics

Threads
1,223,889
Messages
6,175,223
Members
452,620
Latest member
dsubash

Share this page

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