
We need a P&L report that shows COGS as a percetnage of total sales, but we also need to it to show the COGS percentages of each type of revenue.
Example: Sales Food needs to show COGS food and gross profit %
Sales Beer needs to show COGS beer and gross profit %
Do I have to inset a row above every revenue row and reference the associated COGS row?
I need some guidance on this one.
*This post is locked for comments
I have the same question (0)Did you have a resolution for multiple CBR calculations? I am wanting to have two calculated column based off the same actual data, but I don't know how to use two different CBR.