Skip to Content

How to create a BEx which shows distribution of key figure in rows?

The requirement is to distribute key figures in rows. I'm attaching the screenshot of format of report required and also how data resides in the Info Provider.

Kindly help.

Thank & Regards,

Ashutosh.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 20, 2017 at 09:05 AM

    Hi,

    If BPARTNER should be your reference point, then do this to count the number of companies based on your requirements..

    Drag your KEYFIGURE (Auth Cap in Crores) in the COLUMNS section..

    Create a formula for all your groupings..

    FORMULA_up_to_1_lakh = KEYFIGURE <= 100000

    ***I assume that 1 lakh is 100,000?

    In the AGGREGATION tab, choose COUNTER FOR ALL DETAILED VALUES THAT ARE NOT ZERO, NULL, OR ERROR..

    Then under REFERENCE CHARACTERISTIC choose your object BPARTNER..

    It should give you the count of BPARTNER up to 1 lakh..

    Then for your next formula:

    FORMULA_above_1_lakh_to_5_lakh = KEYFIGURE > 100000 AND KEYFIGURE <= 500000

    Same setting in the AGGREGATION tab and reference characteristic..

    And so on........

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded

    • Loed Despuig Ashutosh Agarwal

      Hi,

      Try to do this..Not sure though if this will work..

      Drag your KEYFIGURE (Auth Cap in Crores) in the COLUMNS section..

      Create a formula for all your groupings..

      FORMULA_up_to_1_lakh = ( KEYFIGURE <= 100000 ) * KEYFIGURE

      ***I assume that 1 lakh is 100,000?

      In the AGGREGATION tab, choose SUMMATION..

      Then under REFERENCE CHARACTERISTIC choose your object BPARTNER..

      It should give you the sum of all BPARTNERs with values up to 1 lakh..

      Then for your next formula:

      FORMULA_above_1_lakh_to_5_lakh = ( KEYFIGURE > 100000 AND KEYFIGURE <= 500000 ) * KEYFIGURE

      Same setting in the AGGREGATION tab and reference characteristic..

      And so on........

      Regards,

      Loed

  • Oct 19, 2017 at 07:53 AM

    Hi,

    Sorry I did not understand the screenshots above. Can you tell me the report format you wanted to achieve and the conditions (if there is any) in your query?

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      The main requirement is to show the distribution of a key figure. You can ignore category & class.

      If there are 1000 BPARTNERs and each has authorized capital as 1 lakh, then the row "Upto 1 Lakh" should show 1000.

      I hope the above example clarifies your doubt. So how can i show the key figure distribution in row? How can the condition be given?

      Thanks & Regards,

      Ashuthosh.