Level 3 User Story 1.5 Detailed Sales Targets

Hi Community,

Can someone help me out? I've been stuck on this user story for several weeks now spending at least 40 hours trying to figure this out calculation below.

For line item PY Country and Product Family Sales I can't get to the correct value in order for the Initial Account Sales Target line item to calculate to 670.8 for Nutzo bar for Q1 FY20. Where am I going wrong?

Accepted answers

All comments

Kanishq17

Can you share your formula for PY COuntry and prod family sales , this should not take target but the revenue value by country and product family for the account

Thanks

Kanishq

ShanthiVish

Hello @Anaplanimal

Have you been successful in this? I'm struggling too.

BTW PY Country/Product Sales must be fetched from the Actual Sales by Account/product that you would have uploaded in DAT02 PY Revenue to CY. My issue remains the same though.

DAT02 PY Revenue to CY is by Account/Product and I'm unable to aggregate at Country/Product Family

If you have a breakthrough please reply to my question

IllyaRolinskyy

@ShanthiVishwanath I got it figured out. I was missing one step. Needed to create a DAT04 module dimensioned by G2 Country and P1 Product Family and Time. SUM the data from DAT03 into DAT04, use the SYS02 module to reference your SUM. Then bring in the data into TAR01 from DAT04 into line item PY Country and Product Family Sales. Everything else in the picture above is correct with formulas and data.

Hope this makes sense.

Good luck! I was stuck on that user story for a couple weeks but figured it out eventually.

Quick Links

Can you help?

Unanswered questions

Alternative of Rankcumulate
Is there an alternative to using RANKCUMULATE in Anaplan for cumulative ranking by group? The model's performance is impacted due to the use of rankcumulate. I'm looking for a more efficient approach or best practice to achieve cumulative ranking within groups without degrading performance.
Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.