MAT/MQT/YTD calculations

MAT/MQT/YTD calculations

Hi,

I'd need some help with calculations in Analytics. Having a simple table with data imported from local Excel, how can I do MAT, MQT, YTD and also MAT growth rate and MQT growth rate calculations for different products and countries. Knowing that the MAT is the sum of the last twelve months, and the growth is the sum of the last twelve months divided by the sum of the same months in the previous year and shown as percentage. Is it possible to somehow add these calculations to a table (calculated column?) and show them in charts?