Static Table for Visualization

Hi Community,

I have a dataset which has two columns Booked Channel & Reported Channel, Pax Count for my analysis. I want to create a pivot table visualization as follows.

Channel | Booked | Booked % | Reported | Reported %

The booked Channel and Reported Channel could be different in the same row. I want to generalize the Channel for grouping purpose. I would like to define Channel as a static list using a calculated field and then count the Pax counts as Booked and Reported based on their values in the dataset.

I am sure there are situations you have dealt with this like this. I would appreciate your feedback

Regards,
Giri

Hi Giridhar @Giridhar.Prabhu ,

You said you have two columns in the first sentence and later on said that booked channel and reported channel can be different in the same row. So, Iā€™m a bit confused here.

Please create a sample in Arena to allow other community members to take a shot at helping you.

Regards,
Arun Santhosh
Pr QuickSight SA

Hi Arun,

Sample data would be something like this

What I want as output is something like this

Regards,
Giri

1 Like