1 of 1 people found this helpful
My favorite trick to figuring out what's happening in my table calcs is to make sure I'm "walking" the table in the order I expect.
To see this, create this calc:
That's it. Just INDEX. Put that on your labels shelf. Set the table calc settings the same as the one you are trying to debug. (Table(across)? Table(down)? Etc.) See what your 1-through-N values are. If it's not walking the table the way you expect, modify the table settings on INDEX until it does what you are expecting. When you get it right, that's the setting you should make on your actual table calc.