Loop in calculated Dimension

[danishar]

Hello

I'm trying to split a dimension using the function SubField in Pivot Table

For example:

ItemName_Concatenated=A | B | C | D

(BarcodeCount = number of elements in the chain=4)

= SubField (ItemName_Concatenated, '|', BarcodeCount)

Appears as a dimension

I am able to do this only for one of the letters at a time.

ItemName	A	B	C	D
a
b
c
d
e
f

Is there a way to loop the calculated dimension?

[Gysbert_Wassenaar]

I don't understand what you're trying to do. Can you post a file with example source data and a file with the result table you expect?