Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
66
Views
Topic starter
Hello,
Attache
d herewith is Excel database and a picture of the report required.
Have tried many ways to try add the field Part Time thru pivot table ... but have not got success!
All help will be appreciated.
Thanks
Posted : 22/09/2019 2:47 pm
Hi Pinesh,
Welcome to our forum!
Presumably full time is -1 and part time is 0. In which case, ADD the 'Full_Time?' field to the columns area and change the field setting for the Values to Count, not Sum.
Mynda
Posted : 22/09/2019 7:30 pm
