I am trying to achieve something different, and hope if someone can help me with this. In my report, I have 2 datasets that has MDX queries that references to 2 different cubes. I created 2 tables to display the result of 2 datasets. Well my actual requirement is 3rd table, that will display the difference between values in 2 tables cell by cell. In my report, I don't even need to display 1 and 2 table, its just to used to get the records for 3rd table. Check the file attached, where I have my two tables. The 3rd table should have difference of cells values for every fiscal week.
I tried creating 3rd table without any dataset assigned to it, but it didn't work. I tried to use expression in text field to get the difference between to cells, but it works only for the first record.
I am really stuck at this point, please help!!