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)