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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
You must log in or register to reply here.

Similar threads

C
  • Question Question
Confused over pivot table calculations :-(
Replies
1
Views
638
number kruncher
N
A
  • Question Question
Calculated Pivot Table Field
Replies
1
Views
932
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
250
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,224,820
Messages
6,181,159
Members
453,021
Latest member
Justyna P

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