Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Hope this helps
Regards
Kamiel
Please find attached
Expression: if(TaskID,'X','')
Dimension: All other fields in Dim and manage it accordingly (Columns/Rows)
That's great - but how to add Image_ID here in this pivot?
Hi
Try adding The following as a dimension
aggr(sum(DISTINCT Task_Image_ID),Address)