• Matteo (7/24/2008)


    Another way to do this using more of the native function of the Matrix would be to create a grouping column, where one group value is tied to the Articles sold and another group value tied to the Target information.

    Group 01 is the Articles sold.

    Group 02 is the target.

    The data set would look like:

    grp Name Month #Sold

    == ==== ===== ====

    01 Franz 200801 10

    01 Franz 200803 7

    01 Franz 200804 12

    02 Franz Target -20 (Trick:note negative Target value is need to make the "math" ok when sub totalling)

    ...

    Matteo

    Matteo,

    as a simplification of my approach your idea has the benefit of being easier to understand and maintain.

    It has its limitations, however:

    * When using groups you cannot decide to have a total on the first group only (in the example: on grp=01 but not on grp=02). Reporting Services will add a total column for both 01 and 02.

    * You are limited to sums (Totals). My approach is more generic (and therefore more complex) and can be used for any arithmetic operation (average, multiply sales figures by price, ...).

    Therefore it depends on the actual situation which way is the better way to go.

    Regards

    Martin