Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have this kind of data
now i want max value at the end like .. i am trying which is max in all month by naming category for example
in "a_Col" code_name in a name and in all month max value is 3141 and
for b_col max value is 2139 in all months in b name
so trying to get this type of result
name | month | jan | feb | march | max value for a_col | max value for b_col | ||||||
code_name | a_col | b_col | c_col | a_col | b_Col | c_col | a_col | b_col | c_col | |||
a | 3141 | 2139 | 3141 | 2139 | ||||||||
b | 10458 | 7173 | 388 | 389 | 7173 | 10458 | ||||||
c | 5595 | 544 | 5495 | 3405 | 5755 | 5595 | 544 |
If any question let me know