Max values on the bases of month

[capriconuser]

Kindly find attached file 

i want to find max value from column  on the bases of month like in that data 

Update_month  Jan                                       Feb                                      Dec             max a_col value

code_name       a_col     b_col   c_col   a_col   b_col   c_col           b_col

                                5595       544        5495    3405    3755                         14826

here i want to find max value against a_col and paste it on last column 

Update_month  Jan                                       Feb                                      Dec             max a_col value

code_name       a_col     b_col   c_col   a_col   b_col   c_col           b_col

                                5595       544        5495    3405    3755                         14826                5595

any solution

[juliensaintmaxent3113]

hi,

you do to aggr your measure and use the function total to calculate on the good dimension.

see in the attachment the second measure.

however, the measure is repeated in all column.

Bye

[capriconuser]

hi.. 

in that where is max value at the end ?

[juliensaintmaxent3113]

hi,

you have got two solutions:

the first, in the second colum you have the max which is repeat in each line 

in the second, the measure appears in the line where there is the max

bye

[capriconuser]

no.. i want that max and min at the end .. means want to get max and min at the end like
in jan feb and dec which is max value so that value should be a the end

[juliensaintmaxent3113]

hi,

it's not possible to have in the same table totals for the max and the min and the description

You can make two tables to see the description per month and the min and max .

Bye