Post reply

Reporting Services 2000 - Matrix with Multiple Data Aggregations

  • June 8, 2009 at 2:53 pm

    #210344

    Basically, I'm trying to repeat the same column group headers for two sets of measures. For example, for every row of advertiser, I want to show the unique user count and click count for 3 different ad types (the names of the ad types are my column headers).

    It's very easy to show either user count or click count in separate matrix report, but how can I combine them into one report?

  • June 8, 2009 at 3:20 pm

    #1006326

    One more note: I know I could solve this problem by using multiple column or row grouping if I have aggregated my source data into these two types of counts (user count and click count). But I need to do unique user count at all aggregation levels, so I have to keep the source data at the most granular level.

    Any thoughts?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply