pivot table

[alexpanjhc]

Hello Community

I have a table with the following data

ID	Description	Sub ID	Sub ID Description
1	AAA	123	ZZZ
1	AAA	456	YYY
2	BBB	222	XXX

What I want to show is to show

1              AAA                                                       123                                   ZZZ

                                                                              456                                   YYY

2             BBB                                                         222                                   XXX

unfortunately, i do not have any expressions(quantities) that can help me to achieve this.

I think this is simple but i am just unable to think through.

Any help is appreciated.

[alexandros17]

Just write 1 as expression ...

[#3]

use a dinamic table

dimensions:

ID,

Description,

sub id

expression

only(sub id desc)

[alexandros17]

... It doesn't work if you have two identical descriptions