Hi Quicksight Team,
I have a table with sales number in store level (Please see the following graph), what I want to do is
- Get the P50 sales in City level (P50 sales for all stores in that city)
- Then get the average sales of those P50 numbers in each State (Average those P50 sales for all cities in that State)
Is there any way to do data aggregation from original data table to the final table as shown in the following graph.