Results 1 to 3 of 3

Thread: pivot table configuration

  1. #1

    pivot table configuration



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    from the file uploaded , i need to generate following summery report . How do i configure pivot table to get this ?

    Total Freepool Working on Angular Exit
    IT Services 11 2 6 3
    Arista 9 0 9 0
    AppviewX 1 0 0 0
    Maple 1 0 0 0
    Total 22 2 15 3

    In some cases numbers may not add up to total . Don't bother about it.

    If the data appeares jumbled,see this pls
    Coloumn headings - Total,Free pool,Working on Angular,Exit
    Attached Files Attached Files

  2. #2
    Conjurer Roger Govier's Avatar
    Join Date
    Mar 2011
    Location
    Located near Abergavenny, South Wales, UK
    Posts
    113
    Articles
    0
    Hi

    Your data is in the wrong format to achieve the results you want with a Pivot Table.
    I have used Power Query to Unpivot your data, then added an extra column to the Table called Result (see Sheet 3 in attached file)
    This fills in Exit, if the value is E, or the name of the Group if the Value is Y and ignores any values of N
    =IF([@Value]="E","Exit",IF([@Value]="Y",[@Group],""))

    Then pivoting this new table in the way shown produces your result

    Count of Result Result
    Unit FreePool Angular Exit
    IT Services 2 6 3
    Arista 9
    Maple
    AppviewX
    Grand Total 2 15 3
    Attached Files Attached Files
    Regards

    Roger Govier
    Microsoft Excel MVP
    http://www.technology4u.co.uk

  3. #3
    Quote Originally Posted by Roger Govier View Post
    Hi

    Your data is in the wrong format to achieve the results you want with a Pivot Table.
    I have used Power Query to Unpivot your data, then added an extra column to the Table called Result (see Sheet 3 in attached file)
    This fills in Exit, if the value is E, or the name of the Group if the Value is Y and ignores any values of N
    =IF([@Value]="E","Exit",IF([@Value]="Y",[@Group],""))

    Then pivoting this new table in the way shown produces your result

    Count of Result Result
    Unit FreePool Angular Exit
    IT Services 2 6 3
    Arista 9
    Maple
    AppviewX
    Grand Total 2 15 3
    Thank you so much . That was of great help.

Tags for this Thread

Posting Permissions

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