maximum value
How can I get maximum value for any line item. Dimensions are, days in a year ( 1, 2, 3....) and Item numbers
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | |
| Item 1 | 0 | 2 | 3 | 4 | 5 | 6 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Item 2 | 0 | 0 | 0 | 0 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 0 | 0 |
| Item 3 | 0 | 0 | 0 | 4 | 5 | 6 | 7 | 8 | 9 | 0 | 0 | 0 | 0 | 0 | 15 |
Tagged:
0
Best Answer
-
Are your days in the year a native time dimension or a list with 1-365?
Could you just change the summary method of the line item to MAX?
2
Answers
-
Yes, that helps. Thank you!0