String and numeric data in same column

[Pankhuri]

Hi,
I have a use case where I need to create a single table which has all the customers data, something like this:

|Customer Name|XYZ|
|Customer ID|123|
|Customer country|US|
|Total Sales Amount|1000|
|Total Cash|500|
|Total credit|500|
|Stage 1 Amount|100|
|Stage 2 Amount|200|
|Stage 3 Amount|150|
|Stage 4 Amount|250|
|Stage 5 Amount|100|

I also have a date filter & customer name/manager filter in this sheet.

I wanted how I can implement this. The hard requirement is that the user wants a single Excel download with all the data and they want a columnar view.

Due to the filters causing dynamic aggregation, I cannot do a pre aggregation in SQL and cast as string and display the data. And trying to use an if-else condition is causing the mis matched aggregation error.

[Sanjeeb2022]

Hi @Pankhuri - Thanks for the question. What I understood, your data set contains rows which is essentially have values and you need to do aggregation depending upon the row value. Do you have distinct values of row which is essentially your first column. If yes, you can give a try if else approach in QuickSight and create the fields.

See the documentation link for the same - Ifelse - Amazon QuickSight

Regards - Sanjeeb

[Jesse]

Hi @Pankhuri - try this, use the Table visual and then click the ‘swap rows and columns’ button on the visual menu. After that you can move columns left/right (corresponds to up/down after pivoted).