Straight table Custom dimension and a Value List

[techvarun]

Hello Qlixperts,

I have a straight table with two dimensions

Source = 'H'

KPI = ValueList('a','b','c','d','e','f','g','h','i','j','k','l','m')

So my Dimensions looks like below

Source	KPI
H	a
H	b
H	c
H	d
H	e
H	f
H	g
H	h
H	i
H	j
H	k
H	l
H	m

Now i want to achieve the dimensions as below

Source	KPI
H	a
H	b
H	c
H	d
H	e
H	f
H	g
H/H	h
H	i
I	j
H	k
I/H	l
H/I	m

Thanks a lot in advance.

I have attached a sample qvw

[tresesco]

I guess, from here you should better start thinking about creating an INLINE table with two fields in the script and create your chart accordingly using pick(match(... in expressions.