2 Replies Latest reply on Jan 19, 2017 9:01 AM by Yuriy Ovchinnikov

    % of total for calcuated field

    Yuriy Ovchinnikov

      Hi there!

       

      I am doing some simple calculations, sort of LOOKUP(SUM([Amount]),-5)-LOOKUP(SUM([Amount]),-4) for which i create cal.fields.

      I got my results as absolute values, but couldnt get it as percentages.

       

      I want to compute % of total for ending results. (ending result for item A / total ending result for all items)

       

      To illustrate this I enclosed the workbook.

      Where I have revenue and cost for 5 brands. By using lookup calculation I've got the net revenue (which is revenue - cost) and now I want to have percentage of each brand represents in total net revenue.

       

      Sounds simple, but I'm in frustration.

      Thank you!