Forum Discussion
Create a Measure at a higher level that the report. (Level Metric)
Need to create a measure that is the sum total at the month level.
I have a sum(column) at the report level, but I need a sum at the exact month (level metric in microstrategy). That total month sales would not be on the report per-se but used to calculate additional measures.
I can't seem to figure out how to achieve this. I found a few postings on this topic, but can't see to find a good answer.
| Month | Region | Sales | Total Month Sales |
| Nov-18 | 1 | 20 | 110 |
| 2 | 20 | 110 | |
| 3 | 30 | 110 | |
| 4 | 40 | 110 | |
| 110 |
5 Replies
- parry2k
Super User
Anonymous try this
Total = CALCULATE( SUM( Table1[Qty] ), ALLEXCEPT( Table1, Table1[Month] ) )
- parry2k
Anonymous the measure I provided should work, you need to use matrix visual,
add month, region on rows, sales and new measure I provided on value
- turn on stepped layout on format page
- turn off column total
- drill down to region level.
