Table Help Required

[tahirkhalil]

HI Gurus,

I need an urgent help from you. I want to create the pivot/straight table for some text data - Can someone see the attached file and suggest how to create this kind of table?

Regards,

TK

[kumarkp412]

Hi Thair,

Based on the attachment and requirement in the secound, you can use the pivot table  to make it.

For your reference see the attached QVW

Thanks

Kumar

[kamielrajaram]

Hi,

Hope this helps

Regards

Kamiel

[danansell42]

Please find attached

[tyagishaila]

Expression:  if(TaskID,'X','')

Dimension: All other fields in Dim and manage it accordingly (Columns/Rows)

[tahirkhalil]

That's great - but how to add Image_ID here in this pivot?

[kamielrajaram]

Hi

Try adding The following as a dimension

aggr(sum(DISTINCT Task_Image_ID),Address)