Hi all,
In the attached worksheet on sheet 'List items' Column B ‘Count of items on list’ counts the total number of titles on any given list i.e. list BIOL33391: Molecular Microbiology Full Year has a total of 88 titles on it. Of those 88 titles some will have been digitised and this is defined in column X ‘TADC request status’ – then if I filter column X to show me ‘LIVE’ TADC requests I can see there are 12 Live requests on that list. And if I do a basic calculation I can see that 12/88 is 14% rounded up. So I know that 14% of the content on BIOL33391: Molecular Microbiology Full Year is digitised.
I need my spreadsheet to automate these calculations and wondered if a Pivot table would achieve this but I’m completely stuck and it’s not doing what I want at all – I’ve left in how far I’ve got on the worksheet 'Pivot' but I’m not achieving what I want at all.
I want it to show me data the way I've shown it on sheet 'What I want'
Is this possible, can you help?
Thanks in advance,
Bookmarks