피봇테이블의 헤더의 순서를 변경하는 방법

Question & Answer
, , ,
1

아래 데이터세트를 피봇테이블로 표현하면, 지역(Region)마다 2개의 measure(Forecasted Monthly Revenue, Weighted Revenue)값이 서브헤더로 표현되고 있습니다. 헤더의 순서를 변경해서 measure값마다 지역이 표현되게 하고 싶습니다. 어떻게 할 수 있나요?
데이터 세트는 아래와 같습니다.

Date Forecasted Monthly Revenue Weighted Revenue Region
2011-01-02 00:00:00 103699 10370 US
2011-01-03 00:00:00 393841 39384 EMEA
2011-01-06 00:00:00 326384 32638 US
2011-01-11 00:00:00 76316 7632 US
2011-01-11 00:00:00 162403 16240 EMEA
2011-01-12 00:00:00 116458 11646 EMEA
2011-01-13 00:00:00 47174 4717 US
2011-01-16 00:00:00 102072 10207 EMEA
2011-01-19 00:00:00 157771 15777 EMEA
2011-01-25 00:00:00 103371 10337 US
2011-01-26 00:00:00 551965 55196 EMEA
2011-01-29 00:00:00 112808 11281 US
2011-01-30 00:00:00 469290 93858 US
2011-01-31 00:00:00 485606 48561 APAC
2011-02-03 00:00:00 0 0 EMEA
2011-02-03 00:00:00 529499 52950 US
2011-02-05 00:00:00 0 0 US
2011-02-06 00:00:00 259861 25986 US
2011-02-13 00:00:00 131412 13141 EMEA
2011-02-15 00:00:00 0 0 EMEA
2011-02-15 00:00:00 625302 62530 US
2011-02-16 00:00:00 306569 30657 US
2011-02-17 00:00:00 106928 10693 US
2011-02-18 00:00:00 0 0 US
1 Like
2

Hi @ironpe, welcome to the QuickSight community!

Machine translation:

When representing the dataset below as a pivot table, each Region has two measures (Forecasted Monthly Revenue, Weighted Revenue) shown as sub-headers. I want to change the header order so that regions are displayed for each measure value. How can I do this?
The dataset is as follows:

Based on the above description, I assume you have a pivot table like following, and you want to group region dimensions (e.g. US, EMEA, APAC) under each of the measure names. Correct me if I’m wrong.

image
image885×665 61.8 KB

If I’m not mistaken, I don’t think you can achieve this in a single visual unfortunately, but you can create two visuals, one for Forecasted Monthly Revenue and the other for Weighted Revenue, and place them side-by-side with a little overlap using the free-form layout as follows, so that it looks like what you want.

image
image663×527 36.9 KB

image
image301×635 28.2 KB

When you overlap the visual, you can hide the background and the border so they don’t interfere with each other. Also, you can use the hide single metric option.

image
image585×683 38.5 KB

I hope this helps.

1 Like
3

고맙습니다. 비주얼을 오버래핑하는 방법은 흥미로운 방법이긴 하지만, 헤더와 서브헤더는 고정된 값이 아니라, 동적으로 달라질 수 있습니다. 그리고 데이터셋에 따라 달라질 수 있기 때문에, 이 방법을 사용하는 것은 확장성측면에서 부족할 수 있다.
하나의 데이터세트를 여러 개로 분리한 후(예를 들면, Region dataset, Revenue category dataset, fact dataset) 데이터세트를 조인하는 방법으로 해결할 수 있을까요?

1 Like
4

Hi @ironpe, thanks for your reply.

Machine translation:

Thank you. While overlapping visuals is an interesting approach, headers and subheaders are not fixed values but can change dynamically. And because they can vary depending on the dataset, using this method might be lacking in terms of scalability.
Would it be possible to solve this by separating one dataset into multiple datasets (for example, Region dataset, Revenue category dataset, fact dataset) and then joining these datasets?

I don’t think separating and joining datasets makes any difference here as you will eventually face the same challenge with the joined dataset.

1 Like
5

Hi @ironpe

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

6

Hi @ironpe

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!