Skip to Content
avatar image
Former Member

Group and Sum in Webi

Hi,

I have three objects Business Unit, Department and Revenue

I would like to group by Business Unit and Departement; sum of Revenue.

How to do this in report level?

Please let me know?

Thanks and Regards,

Manjunath N Jogin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 13, 2011 at 06:59 AM

    Add three objects in the query and run the report. Then in report level, apply break on Business Unit and Department. I assume that the aggregation is set to sum for Revenue in the universe.

    Add comment
    10|10000 characters needed characters exceeded

    • I think the answer by Arijit on 'apply aggregation for measure' is slightly incorrect for a object to behave as a measure.

      For your object [Revenue] to behave as a measure i.e do the summing; you need to put the prefix         SUM([Revenue]) in the SQL section of the 'Definition' tab in object property.

      What Arijit explained is how the measure object will behave/aggregated when any of the dimension object is removed from the block.

      Regards

      NK

  • avatar image
    Former Member
    May 14, 2015 at 06:01 AM

    Hi Former Member

    I think what Arijit Das said i correct. Just qualify that object as a Measure and apply the aggregation for that revenue in the Universe. That will work fine.

    Add comment
    10|10000 characters needed characters exceeded