Can i do this in transformer?

[techieaman]

Hi All,

I have two dimensions - Product Dimension & Date Dimension (Granularity is at Month Level) and one fact - Revenue Fact . I need to build a KPI  - % Growth Revenue whose calculation is % Growth Revenue = ((YTD Revenue  - YTD Revenue for the same period last year)/(YTD Revenue for the same period last year) *100.


Can anyone tell me how to go about doing this? I believe Relative time categories have to be built here?

Please reply asap.

Thanks in advance

Aman

[dlafrance]

Try doing a 'YTD Grouped' as a relative time inside the time dimension