Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: MS OLAP question

    I have 100 power plants. Each plant has a random number of generators (1-8). What I need to get in pivot table is:
    average generation by generator and sum of those average for each plant. E.g we have 2 gens in one plant - I need hourly average, daily average, monthly average etc by gen but sum of these numbers by plant. Normally I do simply sum(generation) but I nees sort of mix or sum and avg :<
    Any ideas??

  2. #2
    Join Date
    Oct 2001
    Naples, FL
    Lookup pivot table in BOL or post your DDL for snytax help
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

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