Income Statement % Column

verytiredgirl
verytiredgirl Member
in Beast Mode
image.png

Is it possible to create a Beastmode (or Magic ETLs) to show a column like % of Net Sales?

Tagged:

Answers

  • ColemenWilson
    ColemenWilson Coach

    Yes. Would you mind sharing how your data is formatted? If you provide some sample data I can build the beastmode for you!

    If I solved your problem, please select "yes" above

  • verytiredgirl
    verytiredgirl Member

    Yes I can provide a sample data here (the sample only has 1 month of data)

    Book1.xlsx

    And I'd want to replicate this MTD % column in the Pivot Table:
    Sales is 100%, COGS → Interbranch Charges = % of Sales
    Cost of Other Sales % = (Count Variance % + Obsolescence % + Supplier Rebates % + … + Interbranch Charge %)
    Gross Profit = Gross Margin % - Cost of Other Sales %

    image.png

Categories