3 Replies Latest reply on Mar 2, 2017 10:19 AM by Yuriy Fal

    Why does this table calc change behavior when dimension moved from detail to columns?

    Alex Blakemore

      When trying to make a simplified version of Andy Kriebel's excellent trellis example. http://www.vizwiz.com/2017/02/ww7.html, I ran into a weird hurdle, where moving a dimension from one shelf to another changes the way the row and column table calcs behave (even though the compute using and sort order is fixed).

       

      It appears that the index() function is returning the wrong value in some cases. Or at least a different value that I would expect. Can anyone explain why? Is this a bug?

       

      See the attached workbook.

       

      breaks.jpg