Creating a calculated measure using filtered crosstabs

[cognosdan]

Hi all,

I am quite new to CA i have been previously working with TM1 so forgive my ignorance.
What i am trying to do is create a crosstab C showing the variance from 2 other crosstabs A & B

The problem i am having with this is i have value prompts applied to crosstabs A&B so the user can select a certain year and version for each and then crosstab C should update accordingly to show the variance between the 2 filtered crosstabs A&B

I have tried to create a calculated measure which works on the default values but when i filter my crosstabs A&B crosstab C does not update to show this and only shows the variance between the default values for A&B

I am using a Planning Analytics cube as my data source and using CA version 11.1 R3

If anyone has any ideas i would be super grateful!

Thanks

[Andrei I]

What i am trying to do is create a crosstab C showing the variance from 2 other crosstabs A & B

Are you using the same query for all three crosstabs?