Single 100% stacked bar chart

[Beginner]

I have data in a google sheet

Category	Orders
S	40
S	40
A	10
A	10

How can I create a single stacked bar chart to appear like this?

Thanks

[Sichali1]

Hi,
To get this done, start by creating a dimension called "Category holder" in the calculated field.
Next, set your chart type to a 100% stacked bar chart. Then:
1. Drag "Category holder" and drop into the dimension field.
2. Use Category as the breakdown dimension.
3. Set Orders as the metric.
That should give you the expected chart!
For reference and expected results, click the link below:
https://lookerstudio.google.com/reporting/e84b3fb0-31aa-4d96-967a-458b62188e02/page/mZmCF

[Beginner]

Hi

Thanks for reading and replying.

What should the calculation/value in the newly created "Category Holder" dimension be?

I tried checking via the reference dashboard you created but did not have access to your data set.

Thanks

[Sichali1 · Accepted solution]

Hi,

Here's a picture of the calculation for reference.

[Beginner]

Great,

I am getting same results as you = the results I want

Thanks for your help.