+ Reply to Thread
Results 1 to 2 of 2

Powerview/powerpivot combining data

  1. #1
    Registered User
    Join Date
    10-18-2015
    Location
    Qatar
    MS-Off Ver
    2013
    Posts
    1

    Powerview/powerpivot combining data

    Hi all,

    I am trying to make a comparison between actual spend hours and planned spend hours on a project. But I cannot combine the data because there are no unique value's. I will explain a little bit more:

    The actual hours are summarized by network, department, date, employeenumber, number of hours written on specific date by person
    The planned hours are summarized by network, department, month, number of hours planned for department

    I want to make a table in which the project, department, month are described with the actual number of hours and the planned number of hours. The specific date and employeenumber is not of importance anymore.

    In the image you can see what is looks like, but in the real case there are of course thousands of rows. Anyone has an idea to easily do this?

    Kind regards, Lars

    Capture.PNG

  2. #2
    Registered User
    Join Date
    06-20-2014
    Location
    Cuddalore, Tamilnadu, India
    MS-Off Ver
    MS Office 2013
    Posts
    22

    Re: Powerview/powerpivot combining data

    Hi,

    Pl share any sample excel sheet here

    Regards,
    Siva

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 07-23-2015, 03:35 PM
  2. Powerview / Powerpivot: calculate marketshare
    By tjerkdb in forum Excel General
    Replies: 1
    Last Post: 06-17-2015, 10:48 AM
  3. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  4. Forum for PowerPivot & PowerView
    By NeedForExcel in forum Suggestions for Improvement
    Replies: 3
    Last Post: 02-01-2014, 11:51 AM
  5. PowerPivot & PowerView
    By NeedForExcel in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-22-2014, 05:34 AM
  6. Replies: 1
    Last Post: 09-09-2013, 10:20 AM
  7. Powerpivot: combining complex
    By Obi1 in forum Excel General
    Replies: 0
    Last Post: 11-25-2011, 02:33 PM

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