Display max value for the month

[DestinedTale]

Hi,

I have a graph where i want to display the max value for Jan and Dec. 

Current value: 

Value for jan is 22

Value for Dec is 18

Expected result:

Value for jan is 19

Value for Dec is 16

Expression is 

Sum({$<Context=,FactType={"Customer"},[Month Year]={"$(vPre11Month)"}, Month=,Year= >}[Aging Days]),

[vishsaggi]

Not quite sure about your expression, can you share some sample data and where you want to see your expected output like in a straight table?

[pradosh_thakur]

Where do you want to show the max value ? And again why using sum if you want the max value?

[jonathandienst · Accepted solution]

Create a Month field (if you have not already done so) and add create a straight table (not table box) with month and the ID value as dimensions and Max() for the expression rather than Sum(). Change the total to 'Sum of Rows' in the expressions tab.