3 Replies Latest reply on Feb 23, 2018 2:47 AM by Yuriy Fal

    Percentage of Sales at view level (Op income / Net income / Gross Margin)

    Santos Mummey

      Hello,

       

      I'm trying to figure out how to show an aggregate calculation that will allow to have a calculated field that will show total sales in EVERY ROW within the Net income dimension. I'm building an income statement, and want to show each line as a percentage of total sales. I want the data set to be dynamic, meaning that there are multiple companies and years within the data set, and so I would like the %'s to update when filtering through data.

       

      I tried using an if then statement

       

      IF [* P&L - L4 Sales / COGS]=="Net sales" THEN[Amount (LC)]END

       

      and then a non-aggregate calculated field

       

      {sum([Net sales])}

       

      The second formula gave me a total on every row, but it was totalling ALL company codes.

       

      Here's an example of how the income statement is being built. So for example I would want to see Marketing as a $ of total Net Sales.

       

       

      Any info you can provide would be great.

       

      Santos