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

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You must log in or register to reply here.

Similar threads

C
  • Question Question
Confused over pivot table calculations :-(
Replies
1
Views
616
number kruncher
N
A
  • Question Question
Calculated Pivot Table Field
Replies
1
Views
888
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
234
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,227
Messages
6,170,853
Members
452,361
Latest member
d3ad3y3

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