value list in table

[Anonymous]

I have two headers

Accounts

abc accuont

def account

xyz account

and so on

and another

sub account

abc_a_1

abc_a_a_2

def_a_1

def_a_a_2

xyz_a_1

xyz_a_a_2

......

so when i create table box and select these two fileds this shows like this

accounts      sub account

abc account     abc_a_1

abc account     abc_a_a_2

where as i want like this

accounts

abc account

    abc_a_1

    abc_a_a_2

[marcus_sommer]

Try it with a pivot-table instead of a tablebox.

- Marcus

[ajaysingh285 · Accepted solution]

It wont possible in Table box. you can try with pivot it will works

Thanks,

Ajay