Calculating in SSRS RRS feed

  • Question

  • User-1510915226 posted

    I got a scenario where I want to calculate the revenues for the city(Portland), the developments for that city(Dev.A and Dev.B) individually, and last by the Units for each Development (UnitA, UnitB,UnitC, UnitD, and UnitE).                                                                                                    UnitA and UnitB belongs to Dev.A and the others to Dev.B.

    How would I calculate it with groupings in SSRS when the following are the revenues for each.

    UnitA: $1510

    UnitB: $3313

    UnitC: $3438

    UnitD: $3774

    UnitE: $1432

    Now Dev.A makes in total: $4823

    Dev.B makes $8644

    The City(Portland) makes $13467 with both Dev.A and Dev.B

    I am totally confused as to how to group them to get these figures.

    Much help or hint appreciated.

    Friday, March 1, 2013 7:40 PM


  • User-67082742 posted

    Hi Elvin,

    You may add a parent group on "Dev". Then add a child group on this and group that as well on "Dev".Then right click the group and add a row group by choosing "Adjacent Below" in Row groups. This adjacent group will be on Units.  The result that it would display would be like :

    DEV 1

      Unit A

      Unit B

    DEV 2

     UNit C

     Unit D

     Unit E


    Please let me know in case this does not work for you or this is not the intended result.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, March 3, 2013 11:55 PM