This content has been marked as final. Show 2 replies
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.