Transformation in time, not simple

[omarmtz]

Would it be possible to do the following:

A report where you can select a month, and it will show you the sales for the last four months...

In the Page-by...
Month (Attribute)
&quot;July 2003&quot; <-- This could change depending the user selection

In the grid...
&quot;Jun03&quot; &quot;May03&quot; &quot;Apr03&quot; &quot;Mar03&quot;
..... $30.00 $20.00 $24.00 $15.00

I think that i could use transformations, four metrics... but i would like to name them with the names of the last months...

Thnks

 

[nlim]

I'm going to suggest you create a special attribute called &quot;user selection month&quot;. Make sure it is parent of regular month attribute with 1-to-many. Create a lookup table like this.

selection month regular month
--------------- -------------
july03 jun03
july03 may03
july03 apr03
july03 mar03
june03 may03

etc

then add selection month to your page by, and regular month to the column on your template.