average of measure

[sudeepa]

Hi All,
i have a crosstab created from TM1 Cube.it has Years and Months as separate dimensions. report shows last 12 months data for various measures in rows from selected year and Month Prompts. since year and Month are separate dimensions in cross tab columns Months are nested under year columns as an example shown below when user selects 2014 as year and October(10) as Month

                                 Prior Year ( 2013)        Year (2014)                   Total(Tuple(cm ,prioryear, Monthytg)+tuple(cm,yr,monthytd ) 
                                  Month Ytg                       Month YTd
                                    11 12                       1 2 3 4 5 6 7 8 9 10                 
Measure1                     5   10                      5  55                                      30
                                 
meaure 2 (avg)            5     5                      5   5                                           6 (but is should show 20/12 - 1.6 it is showing as                 10/2+10/10)


Any one can tell me for the measure where it is taking avg how to get sum divided by 12.(avg last 12 months without taking years rollup)