I am using the following formula and receive the correct values for each row of data but I'd like the top row? (I assume this is a totals row) to just sum up all rows below for this particular column. Any suggestions?
Formula for PLvsAP column:
=(sum(VW_FactTradeAllocation[AllocatedTradePx])-sum(VW_FactSessionPrice[ClosePx]))*sum(VW_FactTradeAllocation[QtyTraded])*sum(VW_DimTradeType[Multiplier])
I'd like what is in red to sum up what is in green and it seems its performing some other calc.
Formula for PLvsAP column:
=(sum(VW_FactTradeAllocation[AllocatedTradePx])-sum(VW_FactSessionPrice[ClosePx]))*sum(VW_FactTradeAllocation[QtyTraded])*sum(VW_DimTradeType[Multiplier])
I'd like what is in red to sum up what is in green and it seems its performing some other calc.
Last edited by a moderator:
