It's a bit tough to understand what you're looking for without some screenshots, but here are some things to think about.
- I am assuming you're trying to show the variance between two quarters. Is this supposed to be in a variance column? If so, I would say to use CVC, but that won't work due to the second point. If not, where are you trying to show it?
- If you want the result in a cell where a calculated row and calculated column intersect, you actually have to do the entire calculation in the member filter Row Override (on one of the columns). OneStream doesn't cooperate otherwise. Therefore, you have to do something like GetDataCell [whatever Row8 filters are] - GetDataCell [whatever Row8 filters are, but with a different time period].
- Can whatever is in Row8 be a calculated member instead? Or a UD8 calc?
