Post reply

Reporting Services Crosstab Aggregate

  • September 15, 2006 at 8:02 am

    #113573

    Guys Hi,

    I have added a row subtotal in a crosstab. I also want to add a row aggregate in a crosstab. However i am unable to do this? could you give me any help?

     

    Thank you,

    DF

    "If you want to get to the top, prepare to kiss alot of bottom"

  • September 18, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • September 19, 2006 at 11:04 am

    #661311

    One option might be to utilise WITH CUBE or WITH ROLLUP and the Grouping() function

    Per BOL;

    Grouping is an aggregate function that causes an additional column to be output with a value of 1 when the row is added by either the CUBE or ROLLUP operator, or 0 when the row is not the result of CUBE or ROLLUP.

    Grouping is allowed only in the select list associated with a GROUP BY clause that contains either the CUBE or ROLLUP operator

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

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