Help needed with Crosstab !!!!

[actcognosuser]

Hi All,
          I have a measure Simple interest.(PTR/100).
In a crosstab I am trying to calculate simple interest by day,week,month and year.Daily values look fine.

But in the weekly value, it is doing an average for the whole week instead
of calculating sum(p for whole week) *Sum (R for whole week)* sum(time for whole week) / 100.

I tried to unlock the cell in the week column and dragged a singleton from a different query which has weekly values..Does not work.If I try to add some other measure it goes blank.I guess that is because row and coordinate still remain the same(S.I) no matter what measure i put in there.

              Jan 1|Jan 2|Jan 3 |Jan 4|Jan 5| Week(Jan 1 to 5)
-------- |-----|------|-----|-----|-----|-------------------------------
P           |       |        |       |       |       |
---------|-----|------|-----|-----|-----|-------------------------------
T          |       |        |       |       |       |
---------|-----|------|-----|-----|-----|-------------------------------
R           |       |        |       |       |       |
---------|-----|------|-----|-----|-----|-------------------------------
S.I         |       |        |       |       |       |

Please advise!!!

[MFGF]

Hi,

Have you tried setting the rollup aggregation to be 'Calculated'?

MF.

[actcognosuser]

Hi MFGF,
                I did try setting the roll up property to calculated.Still does not work.It goes blank.Only if i select thesource type as cell value i see some value.But that is incorrect.It is doing an average.