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
QuoteWhat 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?