Multiple criteria agregation|Power Pivot|Excel Forum|My Online Training Hub

Dear all

I have a table of income statement with revenue, cogs, and other exp with sub-ledgers

I wish to calculate net profit which is revenue - cogs - other exp

I used calculate function to create separate measures for revenue, cogs and other exp

and then added those measures (revenue + cogs + other exp) to arrive net profit

Can I arrive net profit in a single measure without creation and adding of separate measures for revenue,

cogs and other exp.  Pls help.

Thanks