Forum Discussion
SWITCH function for P&L Statement
Like many others, I'm trying to build a P&L statement but have hit a wall. My goal is to include "calculated rows" in a matrix such as the following: PLID Category 0 Gross Reve...
Hi johnny1,
"but none of the "calculated measures" for margins or subtotals pull into the result. My guess is that there's an issue with the difference between some of the measures aggregating data from one source table and the rest of the calculated measures that are "measures of measures"? "
<--- What's your expected result and could you please post the measures you are using and the "measures of measures" as you said?
Regards,
Jimmy Tao