I want to create this type of vertical table in quicksight
Sales Profit Volume
2021 YTD 200 300 500
2021 Estimated 300 400 400
2020 YTD 400 500 600
in above - sales , profit and volume are column names.
2021 YTD, 2021 estimated, 2020 YTD are row names.
@bhumika18s I am not clear about the requirements, if you are looking to transpose rows and columns, you can swap/rows columns on a table, see below screenshot
.
If you are looking to pivot data with date as rows and columns, use pivot table visual.
1 Like
Let’s say I have 2023 FY data and for 2024 till June and then I want to forecast about the remaining months of 2024. can i do this ?
Profit Sales Rate Total
2024 June YTD 149943 37373 25
2024 Estimate FY 291786(+29%) 72947(+47%) 25(+2%) 75797 (47%)
2023 FY 225433 225433 49595 22 51956
| Column 1 | Column 2 | Column 3 | Column 4 | E |
|---|---|---|---|---|
| Profit | Sales | Rate | Total | |
| 2024 June YTD | 149943 | 37373 | 25 | 60000 |
| 2024 Estimate FY | 291786 (+29%) | 72947 (+47%) | 25 (+2%) | 75797 (47%) |
| 2023 FY | 225433 | 49595 | 22 | 51956 |
Let’s say I have 2023 FY data and for 2024 till June and then I want to forecast about the remaining months of 2024. can i do this ?
Hello @bhumika18s !
The original topic was closed as a solution, could you please repost this question at the top of the community so that it is a priority for our experts?
When you repost your topic you can link to this one for context about your question.