Is there a formula I could use to say: If Total CSG Sales for Programming does not equal Per P&L sales for Programming, allocate the total Per P&L sales to each state to equal Per P&L sales?
Thanks!
Solved! Go to Solution.
Hi @bethgrap ,
in my understanding, "Total CSG Sales" is the total of the states values above, right? I would split off the two total rows (text length > 2 could be used to select), calculate the relation between the values and multiply this relation with the state sales figures. I've attached a sample workflow. What do you think?
Best,
Roland
That works!
But now, how would you get the Total & P&L columns back to rows?
Thanks!