Skip to Content

Sum() distinct in Merged Dimmension

Hello,

I would like to know how to correctly sum in merged dimensions.

For example, I merged the following objects: [ID],[Month] and [Total], in one of the universes there is an additional value so I expect that my Sum([Merged Total]) function will return only 66.84 and not the sum of the total in both querys.

I cannot specify the context in the sum because sometimes there is data in universe 1 that doesn't exist in universe 2 and vice verse.

Thank you guys.

bo.png (26.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Oct 22, 2019 at 02:50 PM

    If ID and month are merged objects then try to add below formula to display data form both queries measures.

    =sum([Query1.Total])+sum([Query2.Total])

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 22, 2019 at 03:10 PM

    in this case pass the output of one query as a input in second query in webi queries.You will get the values only which are available in query 1 and query 2

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 23, 2019 at 01:09 PM

    Hi,

    You can use a union query,

    the above requirement can be handled by the union in the webi report query.

    thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 24, 2019 at 02:40 PM

    I have used the "Extend Merge Dimmensions" and now the sum in the Merged total is correct.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.