Breakback on List items

SriNitya
Occasional Contributor

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

3 REPLIES 3
Misbah
Moderator

Re: Breakback on List items

@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
Occasional Contributor

Re: Breakback on List items

@Misbah 

 

Hi

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
Moderator

Re: Breakback on List items

@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.