Converting one column with three variables to three columns with a variable or without

Question & Answer
1

Basically my data looks like this:
Type A 3000
Type B 5000
Type C 7000
etc…

And I need it to look like this:
Type A 3000 Type B 5000 Type C 7000
Type A 2500 Type B 0 Type C 8500

This is simplified, but basically I want to parse out the original column to three separate columns based on the three types while still keeping the original type column. I know this can be done in the query, but if that weren’t an option, is there a way to do this natively in Quicksight?

2

@misha_lia03 : Are you planning to achieve below in QuickSight.

image
image751×262 6.1 KB

Please confirm so that we can explore this.

Regards - San

3

Hi @misha_lia03

Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 7 days, we will archive the question.

Thanks

1 Like
4

Hi, sorry for my late response. Yes, this is exactly what I’m looking for.

1 Like
5

You can make a pivot table and use the type as columns.

You cannot do this with a calculated field in quicksight

2 Likes