calculations between two different datasets

  • Hi!

    I was wondering if I could get some help please?

    I'm trying to perform a calculation between two different datasets in RS 2008.

    Here is an example:

    =order closed [dataset1] \ head count [dataset2] \ 20 where region [dataset 1] = [some criteria]

    The difficultly I'm having is that I can only have one active dataset per matrix (or table).

    I've searched all over for an answer and it seems the answer I'm gettign is that it's not possible.

    Has anyone tried to do this??

    Thanks,

    Michelle 🙂

  • I think you can reference a different dataset by specifying it in your expression. For example, where the second dataset (the one not attached to your table) is called SalesData:

    =Sum(Fields!Sales,"SalesData")

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

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