Load calculated fields

[#1]

hi everybody,

I am trying to load a mysql table in QV, but i ma facing issues to display results.

SO here is my problem:

- i have a table (mysql) with columns filled with financial data

- rows are representing financial data for projects

- for each row i have the project code, the reference month and other columns for financial data (see attached file)

- I am focusing on the project code, the reference month and the actuals turnover (the turn over is a sum of 3 columns)

- Now i want to load these rows following below rules:

                       a)  for each project i want to get the value of actuals turnover but only at end of quarter (ie. march, june, sep, and december)

                       b)  for each project i want to have the quarterly turn over using these rules:

                                                     Q1 turnover=Q1 actuals,

                                                     Q2 turnover=Q2 actuals-Q1 actuals,

                                                     Q3 turnover=Q3 actuals-Q2 actuals,

                                                     Q2 turnover=Q4 actuals-Q3 actuals

The data covers 2011 and 2012.

Regards