请教下,我要求COLUMN 的VALUE 要用什么COMMAND啊..
我的CHART 里有 24行数据, 分别2年12个月的MONTLY RETURN, 如果我要求ANNUAL RETURN, 这个要怎么搞啊?
我现在的做法是每年的MONTHLY RETURN 单独成一个CHAART, 然后 TRANSPOSE, put the month return in row, then create new varibale as annual return. then combine the charts for two year together. ..
but my question is what if there are 20 years monthly return, then I have to creat 20 chart for each year, which is really not efficent. ..so can anyone help?? thank you so much!