Change the header based on the type

[#1]

I have a table like this

Toy Code, Description, Type

1,aaaaaaa,infant

2,ggggggg,infant

3,fgfggggg,toddler

4,sfgfdgfgg,toddler,

5,gdfgddfgg,infant

I want to show a table like this

Infant:

1     aaaaaaa

2     ggggggg

5     gdfgddfgg

Toddler:

3     fgfggggg

4    sfgfdgfgg

I am trying to achieve the above with a table box but unable to put the different headers. Can some one please help?

Thanks,

[Miguel_Angel_Baeyens]

Hi,

Table boxes are intended to show information, not to format or do any kind of transformation. Instead, use a Chart > Straight table or Pivot table and use those fields as dimensions.

Hope that helps.

Miguel

[#3]

I tried that approach, but the Straight table and Pivot table are expecting expression which I don't have any in this scenario.

[Gysbert_Wassenaar]

Check the options Show All Values and Suppress When Value is Null. You won't need an expression then.

[#5]

Thanks for your response. This worked. But I still having difficulty putting Type as the Header. I have defined all the three columns as Dimensions in the Pivot table. How can I make the Type field to show as header as follows.

Infant:

1     aaaaaaa

2     ggggggg

5     gdfgddfgg

Toddler:

3     fgfggggg

4    sfgfdgfgg

[Miguel_Angel_Baeyens]

Yes,

Or use 1 as expression then hide it, that will do as well. Or use "Toy Code" and "Description" as dimensions and "Type" (the field name) as expression that will also work.

Hope that helps.

Miguel