Calculating Column % based on Row value
In Income Statements is common to calculate a % based on a "Net Sales value" in a row, as follows.
|Statement Level 2||Jan||%|
|Rebates & Other||-$14,254,654||5.9%|
|Rev. & Inv / non Recurring||-$305,707||0.1%|
|Allocation - Mfg Variance||$11,029,040||4.6%|
|Allocation - Staff||-$4,119,284||1.7%|
|Samples - Expense||-$351,480||0.1%|
|Selling & Service||-$13,282,339||5.5%|
|Allocatioin General Selling Exp||$0||0.0%|
Any suggestions to build this in beastmode?
I tried calculating in my dataflow an additional column with the "Net Sales Value" for every row, and it worked.
But when I start to apply filters to the card (e.g. by region), the calculations are incorrect because the "Net Sales Value" is valid only "without filters". So I need to calculate this "Net Sales Value "on the fly" in a beastmode formula.
Any suggestions for this?