Pivot table to reduce number of rows

Question & Answer
1

This is my current table structure:

image

This is what I am looking for:

Segment API Mobile Web
Enterprise 1,739,410.3 3,459,504.5 4,661,960.09
SMB 410,281.84 939,104.25 1,247,303.96
Startup 2,621,454.13 5,702,420.6 7,898,458.36

Can I pivot this table in QuickSight so [Channel] values become columns?

2

Hello @Nickson40 and welcome to the Quicksight community!

In the screenshot below I used a Pivot table visualization to create a similar set up. In the Field Wells at the top you could replace my field {Regions} with your {Channel}.

Screenshot 2023-07-12 141335
Screenshot 2023-07-12 1413351068Ɨ517 46.7 KB

Let me know if this helps!

1 Like
3

This is exactly what I was looking for. Thank you @duncan !!

1 Like
4

@Nickson40 Awesome, Iā€™m glad that worked!