Aggregate value of lineitem

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

Any help appreciate ..

Thanks

Jerin

Accepted answers

All comments

einas.ibrahim

Hello @Jerin_KJ

Do you want to have the same sum value for the country to repeat for each account?
so the values for the last line item called Total Revenue by Country will be 72000, 72000. 72000,…

Is that your goal?

(72000 is roughly the sim of the numbers you provided.

ManjunathKN

Hi

Remove the Accounts dimension in your Total sales revenue by country and refer the line item above(Total sales revenue by account). you will get your desired results and make sure to switch on the summary to sum.

Thanks,
Manjunath

Jerin_KJ

Yea same value ..

Jerin_KJ

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.

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

Thanks

Jerin

ManjunathKN

Hi

Please remove the account dimension only in that line item(country total sales revenue and keep the summary sum) but please keep in main applies to, otherwise all the data related to account dimension will be blank.

Thanks,
Manjunath

ManjunathKN

Hello,

Your dimensions for line items should be something like this.

Line Items	Applies to
Accounts	Accounts,products
Country	Accounts,products
Total sales revenue by Account	Accounts,products
Total Sales revenue by country	Products

Thanks,
Manjunath

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…