How to show number customers by multiple dimensions

[nellygamil1]

Kindly looking for help,

I have a dataset similar to the below, where customers are segmented in 2 types. the data for both segments is in the same table.

I would like to add a stacked column chart showing total number of customer by Type A segment in X-Axis and Type B count of customers is in the legend.

What I need to do is mimic as if the data was stored in the below format

Many thanks in advance,

Nelly

[Idrissshatila]

Hello @nellygamil1 ,

Did you try to add the segment field as a legend  ?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[nellygamil1]

Hi @Idrissshatila ,

I tried and it does not work since both my segment types are stored in the same column. I need to be able to separate them as if they were stored in 2 different columns for the same customer as shown below.