@anirudh Hi, Thanks, I have tried that and the forumlas wont breakdown. For the Revenue line, I need a different formula in each column and when I try insert subsets the formula drags down to each line item in the column
Hi @ciara Before I suggest a solution can you please help me confirm my understanding of the issue
The P&L line item such as Revenue and COGs are Line Items in the modules?
The items in the columns are in a List?
What are the other dimensions in the module?
What is the logic for calculating the different values in the columns?
Some are multiplied by a ratio from another module and others are a simple addition/subtraction?
I had to add a KPI line item on a P&L which had a different calculation for each P&L line item (P&L was a Line Item Subset). I think that might work with your situation.
Einas "Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Dear community members Consider posting your question as a new topic and not in the thread of another topic/question. This help other community members to easily find the answer they looking for and doesn't cause the original thread to be so cluttered that we can't find what we are looking for