Hi, can someone help me out to create a pivot table as shown in the image. And help me on how the data should look like in the table to get the output like above.
1 Like
Hi @Tejasai99,
This would depend a bit on how your dataset is setup and the fields that you have available to be utilized. Is this screenshot taken from an excel workbook? The easiest way for the community to assist further with a request of this type, would be for you to create a copy of your analysis within the QuickSight Arena view (with anonymized data), so that we can see what the available field options are, the format of the fields and what the value options within each field that will be utilized are.
Additionally, for something like 'Net Total (Net of Reversals), please include some information on how those numbers need to be calculated, and what fields would be utilized within that calculation.
Here’s some additional information on how to create a QuickSight Arena view: