Skip to Content
author's profile photo Former Member
Former Member

Custom Subtotal in BEx

Hello All,

My requirement is to get the below custom total:

How can i achieve this in BEx?

Thanks in advance

MD

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2014 at 05:23 AM

    Hi MD,

    If I understand correctly, you need to display total based on char. Then you can select result rows for this particular char. If result is not not giving correct value, then you can also create a formula variable displaying this KF and set exception aggregation as summation for this char.

    Hope this helps.

    Thanks,

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      As you said, you are using exception aggregation for this formula. If you are already using some meaningful defination for exception aggregation, then you can create one more formula over your KF formula and try below, OR else you can you try this in you existing formula:

      And make reference characteristic as char9. Remove upper setting calculate result as total and please confirm what result you get .

      Thanks

      exp1.JPG (33.6 kB)
  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2014 at 08:20 AM

    Hi Manna,

    A very simple way of doing it is adding a selection to your query. Select your key figure in it and add char as constant selection. that will solve your problem. But in each row it will show the total amount.

    Regards

    Yasemin...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Manna,

      If you have any characteristic that will help you decide on which row the subtotal should be viewed, then you can achieve your requirement. You could get this value with replacement path, and add a formula to your query where you write a formula such as

      (Replacement_Path_Variable = The_Value_for_the_total_to_be_shown, KF, 0)

      Regards

      Yasemin...

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.