Forum Discussion
Anonymous
7 years agoNot applicable
YTD Issue
Order Entry = CALCULATE(SUM(Central[OrderConfirmationValue]), Central[Document Type]="Order Entry")
Net Sales = CALCULATE(SUM(Central[OrderConfirmationValue]), Central[Document Type]="Net Sales")
Order In Hand = [Order In Hand] - [Net Sales]
My requirement is YTD
Jan Feb Mar
Order Entry 100
Net Sales 10
Order In Hand 90
How can do this using matrix
2 Replies
- AnonymousNot applicable
- AnonymousNot applicable
I want to add these three measures in values field in matrix.