Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
hi..
in that where is max value at the end ?
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
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