Hi Andrew,

Thank u for ur reply. The thing is i have the excel requirement. I have the data like **Service _Year_Month, Sum(Total Cost), Sum(Labour Cost), Sum(Material Cost), Sum (IB Count). **The thing is They builded reports in excel. In the same way i have to make in spotfire. For that fst they did like sum(total cost) /sum(ib count). Then got some value. so for that values they found 12 month rolling cost. For that they took last 12 month sum including curent month -previous month. i did like sum(total cost)/sum(ib count). then I tried by using the calculation like **sum(total cost)/sum(ib count) OVER (lastperiods(12,[service_year_month]/12** ,,,,but i didnt get the exact values compared to the excel data.

How to filter 201505 to 201604? i need only these 12 months

i alreay given the columns. so for this data what calculation should i write? iam very new for spotfire.

please help me

Regards,

gurusai.