Convert Table to PivotTable

Hello everyone,

Due to the limitation of pivot table visual that it cannot display value as text or url as images, I try to create extra calculated columns to show the text/image.

My original table has 4 columns product category, product group, month, photo_url. I created 12 calculated columns for 12 months such as ifelse({month} = 1, {photo_url},“”) as “January”. Then I create a table visual and drop all columns to group by. The visual shows me this. It creates extra rows for each calculated column. :frowning:

What I want is this. Just one row per category per group and all url pictures across for all months.

Please let me know how I can fix this. Thanks a lot!

1 Like

Hi @AnwarAli - Can you please advise on this. Looks like it is bit tricky question and how we can achieve this in QuickSight.

Regards - Sanjeeb

1 Like