I want to create a cross tab report which will show the End of period values rather than the summing of the values.
The data looks like this
The page filter will be END_OF_Moth
So the measure column "Value" Should show the values based on the page filter. Like, if the page is not filtered then it should show 29-Feb-20 values. If let's say the page is filtered on "31-Jan-20" then for cat 1 it should show for Cat1/LOB1 cross tab (21+19) = 40.