Table visualization cols to rows + percentage

Question & Answer
1

Hi,

Been breaking my head over this

I have the following dataset:

| date | Principal | Interest | Commission |
| jan-01-2023 | 300 | 10 | 5 |
| jan-02-2023 | 500 | 8 | 6 |

And I want to create the following visual table for january 2023:

| Income | $ | % |
| Principal | 800 | 96.5% |
| Interest | 18 | 2.2% |
| Commission | 11 | 1.3% |
| Total | 829 | 100% |

Thank you in advance

2

Hi Enrique,
In your table visual, just change the Group by in the field wells to Month aggregation and then use the transpose icon at the top right of the table visual to swap ros to column in your table. Refer screenshot.

image
image1472×802 129 KB

Hope this solves your question.
Regards.

3

Thank you Raji,

so far so good, how can I add the total of the transposed col (43,971 + 25 + 7,140) and how do I add the percentage column?

4

@Enrique_Martin, you can edit the table visual properties to add the total for the table. For the percentage column, you can create a calculated field and define a custom % calculation or use one of the QuickSight percent functions such as percentOfTotal - Amazon QuickSight
.

Hope this provides answer to your question. I am marking @Raji_Sivasubramaniam reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!