5 Replies Latest reply on Nov 2, 2018 10:39 AM by Robert Priewe

    Show the grand total in each row (LOD?)

    Robert Priewe

      Hi,

      i'm trying to create a column that shows the grand total in each item, here is an example what i'm trying to achieve (the column with the 25 in each item:

      Untitled.png

      I think this is done with a LOD calculation but i'm not sure how. The reason i need this column is so I can calculate a ratio between the price in each line item and the grand total.

       

      I've also attached a packaged workbook.

       

      Thanks for the help!

      Rob