How to present data on monthly basis, that originaly is presented on quarterly basis

[#1]

Hi everyone, I have trouble with presenting monthly data from a quarterly source using variables. Basically the problem I am facing is that I am unable to divide my final result to three equal values. The data is presented on monthly level and can be collapsed on quarters. Could you please advise what formula/function should I use.

Thanks in advance.

[swuehl]

If your quarter field values are based on dates (AKA a QuarterStart date), try something like

LOAD Value / 3 as Value,

           AddMonths(QuarterStartField, IterNo()-1) as MonthStartField

RESIDENT YourTable

WHILE IterNo() <=3;

to create monthly values from quarterly values.

[Anonymous]

please share the sample data...