I have a matrix that have have dates in rows, locations in columns, and current months sum for each location, previous years of the exact month sum, and percentage change between the two as the values. However the total of each row is not correct. In the image below, i omitted the different column locations. The values of each column are accurate as i crossed referenced with the real data, but the total for current, prev (in red) are not when I add them up manually. Is there any setting that is causing this? Thanks.
Thanks for your reply. I tried the suggestion that you refered me to but it didnt work. But I kind of know why it is doing it now. To better explain it here is my table again with the locations 21 - 30 (each representing a location).
Just focusing on the 'current' measure. Location 30 needs to have its value multipled by 2.1, and all other locations are just sumed up regularly. The values are taken by two methods: method1 and method2.
So the problem is when the Total Current is summed, it is getting the current from all locations and that includes location 30. And it does not use the calculated Current of Location 30, becaue of the nature of the condition.
I am trying to find logic to take in the Current of 30, but if I do that, the Current of the other locations would use that as well in their values. Is there any way to reference the Total column so I can include that in the IF statement. Or do you have a better alternative from what I am doing? Thanks.