I have a MATRIX report that has two datasets. In dataset one, there is a total line I named "GM". In dataset two, the total line is named "OE". Under OE, I want a calculation that takes GM-OE. Because it was not calculating correctly, I changed the line under OE to just give me ReportItems!GM.value to see what value was getting filled there, it is using the last column total for the value in each column before it. I want JAN GM to reference JAN line under OE, not MAY's GM value. Any ideas??
See screenshot:
