Results 1 to 2 of 2

How do I show percentage in a Pivot table?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-09-2011
    Location
    Perth, Australia
    MS-Off Ver
    2016
    Posts
    161

    How do I show percentage in a Pivot table?

    Hi Forum,

    I am trying to show percentage in a Pivot table and can't believe how complicated it is!

    My data is sorted by "Position" (Carpenter, Welder, etc) and within this is "Type" (Direct [direct labour] or Sub [sub-contractor]).

    For each "Position" I want to show what percentage is Direct and what percentage is Sub.

    For example, in Row 8 the Position is Carpenter. I want to display what percentage of Carpenters are Direct and what percentage of Carpenters are Sub.

    What settings do I need to achieve this?

    Please see attached sample file.

    Thanks very much.

    Dave
    Attached Files Attached Files

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