+ Reply to Thread
Results 1 to 3 of 3

Pivot to show summary including %

  1. #1
    Registered User
    Join Date
    12-04-2018
    Location
    Derby, UK
    MS-Off Ver
    2016
    Posts
    22

    Pivot to show summary including %

    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,
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019
    Posts
    384

    Re: Pivot to show summary including %

    Hello,
    The easiest way is with the auxiliary column and the computing field.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-04-2018
    Location
    Derby, UK
    MS-Off Ver
    2016
    Posts
    22

    Re: Pivot to show summary including %

    Thank you very much stasinek!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1