Aggregate value of lineitem

Options
Jerin_KJ
Jerin_KJ Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
in Planning & Modeling

Hi team,

 

 I need to aggregate of a line item-1 with number of accounts  and display in another lineitem2 in same module.

Line Item 1 - Total Sales Revenue by Account (Each product family has number of accounts under it)

LineItem 2 Total Revenue by Country = SUM of account sales target  of all the accounts coming under that country and product family. Screen shot below.(13868+24418+14757+19180) for chocolate family 

 

Jerin_KJ_0-1649900221680.png

Any help appreciate ..

 

 

Thanks

Jerin

 

 

Tagged:

Comments

  • Jerin_KJ
    Jerin_KJ Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
    Yea same value ..
  • Jerin_KJ
    Jerin_KJ Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

    Hi Manjunath,

     

    When i remove Account diamension i got the country total sales revenue , but Account & country refering from anothre module become blank now. i added same formula but not working now.

     

    Jerin_KJ_0-1649921126325.png

    Why country sales target not getting previously and now how i can resolve issue.(blank account name and country)

    Jerin_KJ_1-1649921209339.png

    Thanks

    Jerin

Categories