Results 1 to 1 of 1

% of one product against the other not working

Threaded View

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    20

    % of one product against the other not working

    Hi all,

    Once again thanks for all your continued help ;-)

    I have a pivot table with

    Sum of Total Enrolled Devices
    Sum of total Active Devices2

    I have both the sums in the value filed in the pivot table and am trying to work out the % of Active Devices against Enrolled Devices for each month as per the table attatched.

    In the pivot I have right clicked on Active Devices and chosen Show Value as % of and clicked on Enrolled Devices in the drop down box. However the value should be 83% but this isnt showing? I have tried and worked it out but its not working? Am i missing something obvious?

    Would really appreciate your help as this is something which am struggling with but thought was straightforward!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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