I am not sure how Tableau reads the DynamoDB data. But you need to pivot your data as :
ITEM1, Location: A, Type: 1
ITEM1, Location: B, Type: 2
ITEM2, Location: A, Type: 1
ITEM2, Location: A, Type: 4
ITEM2, Location: B, Type: 6
and so on...
Not sure if Tableau's pivot feature can help you on this.
After pivoting it will be easy for you to do any analysis.
So I understand that if I can split my column into multiple rows like that it will solve my problems. I'm asking how to do that.
Part of what's getting me is that while for my Types dimension, I know that I will have a fixed number of possible values (no location can have less than 0 or more than 9 types), my Location dimension is of an unknown size. Depending on the item, there could be 4 locations or 40. And I don't know how to deal with this.