maximum value

pkramesh

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

jasonblinn

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?

 

 

pkramesh

Yes, that helps. Thank you!