Skip to Content
0
Former Member
Jun 01, 2015 at 04:51 PM

CrossTab Report individual cell reference

62 Views

Hi,

I am having a problem in one of the crosstab reports I have designed. I am not able to get the appropriate values in the calculated member column of my report. In the report data is split into rows based on territories (e.g. D001107) and the columns are a split by month. The yellow line (Actuals) which you see here is a calculated member line and it is supposed to come after the current month (which is an input). For example if you run the report for 03.2015 then Actuals should come up after March 2015.

I’m having problem here to populate values in the calculated member column. I need to sum the values for the cells before Actuals and display them in this Actuals cell (e.g. for D001107 Actuals for A1 should be -27826 + 0 - 34671). I tried using something similar to the formula in A1,B1,C1,D1 but that is not working because the Month calculation is based on a formula which in turn splits A1,B1,C1 and D1. When I use the same approach I get incorrect values in the calculated member column. I want to know if there is a way that I can refer to individual cells in the crosstab and sum them up. I mean if I can refer to Row A1 Column January – 15 and use it in the calculated member or if anyone could suggest some other way it will be of great help.

Thanks!

Attachments

Image 1.jpg (97.4 kB)