Breakback on List items

Hi All,

I have a list product list P4 and a filter is applied on it i.e at P4 level only few items should be shown based on selection.

Break back is enabled on all levels.

In P4 5 items are there only 2 items belongs to category 1 and 3 items to category 2. Our requirement is that If user select Category 1 and enter data at P3 data should split only for 2 items & if Category 2 is selected data at P3 data should split only for 3 items.

P3 Data entered -10000 P3 Data entered -10000

category 1 - selected category 2 - selected

ITEM 1- 3333.33 ITEM 2- 5000

ITEM 3- 3333.33 ITEM 5- 5000

ITEM 4- 3333.33

Need a workaround on this when break back is applied.

Thnaks

Sri Nitya

Accepted answers

All comments

Misbah

@SriNitya

Instead of using Native Breakback use Top down approach and try to cascade the values down by Using LOOKUP function from Parent to Child.

1. Create a module dimensioned by Categories and Insert two line items.

X Line item - Formula should be = Module 2. Count

Y Line item - Input the numbers against Categories

2. Create another module dimensioned by Products and insert two line items

Count = 1

Value = Y Line item[LOOKUP: SYS Product Module.Categories]/X Line item[LOOKUP: SYS Product Module. Categories]

Misbah

SriNitya

@Misbah

Thanks for your reply

But user will enter data at Product levels P1 to P4. Categories selection is applied as filter to the Products.We have mapping of Categories to Products and Input is done at Product level only.

Regards

Sri Nitya

Misbah

@SriNitya

Ah I see, so category is just an attribute and is not part of the hierarchy.

Breakback works on totals of simple hierachies and if you enter certain amount on a Parent it will be distributed into all children (unless there are read only cells or held cells) no matter how many filters you apply. For Example if Product 3a and Product 3b has Category 1 as an attribute and Product 3c is category 2. Now if you wish to cascade the numbers of Category 1 from Product 3a and Product 3b to Product 4 level children it has to come from their respective Parents which in our case is Product 3a and Products 3b.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…