Version SAP BI 4.1 SP 5
I have a scenario where I need to get a count of a dimension(date) values from one query and take this count and multiply it with a dimension from other query(where the date values are excluded).
(lets say Query 1 has 12/1/2016, 12/2/2016 and 12/5/2016 count is 3
Query 2 max date value is 11/30/2016)
I have tried creating variables, forcemerge and other methods.
I'm restricted to do this only at report level.
Please let me know if we can do something like a value from block 1 into blank cell(or somewhere in the report) and then use this blank cell as source to my calculation WITHOUT taking the underlying formula from block 1. (Similar to excel where we say A1 = B1 and B1 = D2, so when A1 changes all the cells change)