how to change calculation dimension in pivot table

[#1]

Hi all,

I'm hoping this is possible.

I have a pivot table with the dimension month(futuredate)

Two expressions sum(futureamount) and sum(actualamount)

When calculating the sum of the second expression I need to calculate it based on the field actualdate.

I've looked at set analysis but can not see how this can be accomplished.

Thanks for any help

[#2]

Hi, do you mean you want to calculate it where futuredate=actualdate?

[#3]

Hi thanks for looking at the post.

In fact, yes, I do need to calculate the actual amount paid based on the actual month that the payment was made in.

The table(s) look as follows

table1

primary key|futuredate|future payment

table2

foreign key|actualdate|actual payment

the two expressions are the sums of the future and actual payments

[#4]

Hi, is it an option to link the two tables? If not, could you please post a sample qvw of your problem?

Cheers, Lukas