I have a use case where I need to create a single table which has all the customers data, something like this:
|Total Sales Amount|1000|
|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.