Results 1 to 2 of 2

Thread: Mysterious Measures

  1. #1

    Mysterious Measures



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

    Hi all,

    I'm relatively new to PowerPivot, so this question is probably going to make you laugh. Anyway, I'd appreciate it if someone could help me on this.

    I have 2 data tables. One shows the amount of clicks on a website in 5-minute buckets (per day), the other one shows the amount of seconds of TV spots (also in 5-minute buckets per day).

    I want to create a pivot table combining these two, making the amount of clicks and the seconds of TV spots comparable (essentially trying to figure out the impact of the TV spots).

    I've linked the two datetime columns in the PowerPivot window.

    However, when i create a pivot table, using the datetime column of the TV spots as rows (sorry, using German excel, not sure about the 100% translation) and adding clicks and seconds as values, only the seconds are porperly summed up. The clicks are displayed as the overall total of all clicks. Vice-versa if I use the datetime column of the "clicks" table (clicks are properly calculated, minutes shows as overall total).

    I KNOW I need to insert a Measure somewhere, but I can't figure out what this measure should calculate in order to display the clicks properly calculated (or the seconds).

  2. #2
    Excel 2010, Tables, PowerPivot, PivotChart
    Multiple Web/TV-Spot agents, multiple hours.
    Count Web hits and Spot seconds during one day.
    2.0 MB
    http://www.mediafire.com/view/pj440d...12_04_13a.xlsx
    http://www.mediafire.com/view/7rtq1n.../12_04_13a.pdf
    Last edited by Herbds7; 2013-12-05 at 04:13 PM.

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
  •