# Drill down one by one in every expand click

**URL:** <https://community.amazonquick.com/t/drill-down-one-by-one-in-every-expand-click/12609>\
**Category:** Q&A\
**Tags:** pivot-table, feature-request, quick-sight\
**Created:** [April 24, 2023, 8:39am UTC](https://community.amazonquick.com/t/drill-down-one-by-one-in-every-expand-click/12609 "2023-04-24T08:39:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jose\_Siles](https://avatars.discourse-cdn.com/v4/letter/j/eada6e/32.png) [@Jose\_Siles](https://community.amazonquick.com/u/Jose_Siles)\
**Post date:** [April 24, 2023, 8:39am UTC](https://community.amazonquick.com/t/drill-down-one-by-one-in-every-expand-click/12609/1 "2023-04-24T08:39:08Z")

</div>

Good morning,

I’ve a pivot table with differents level of granularity at rows, imagine something like Country - State - City - Neighbourhood

My client wants me to implement 2 things:

1. Dashboard should be always start collapsed as a starting point, so, whenever and whoever opens it should be full collapsed.
2. When I expand the Country ONLY expands at State level, right now, it’s doing a full expand until Neighbourhood.

Can anyone help me to implement the desired solution?

Thanks!

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [April 24, 2023, 6:50pm UTC](https://community.amazonquick.com/t/drill-down-one-by-one-in-every-expand-click/12609/2 "2023-04-24T18:50:34Z")

</div>

1. When you publish the dashboard you can close the pivot table and it should load the same way you published it.

2. In regards to expanding it one by one. You’ll need to close it one by one first.

Everything open:

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/7/78979982738c6f38b2cf81dc16b272b494b724d2.png)

First one closed:

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/6/61a17524050a99c1e64f61e731dba17af6ef32ea.png)

Open it back up again

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/e/e2d490a168618a68a4ee47da3aa37db0c4564607.png)

However now I’m going to close one arrival timestamp.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/1/1386fef5ed60ab8777957c6ffbb80a7b2f720d77.png)

Then close the first column.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/9/95b775fe9d45e566d083bae9072cbd5ff065203b.png)

Then open the first column.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/2/22400978cd8b345da3bfdefa4ee2695b58c2940b.png)

You’ll notice that the first arrival\_timestamp is still closed.

Let me know if that helps you out.

---

<div class="post-metadata">

**Author:** ![Jose\_Siles](https://avatars.discourse-cdn.com/v4/letter/j/eada6e/32.png) [@Jose\_Siles](https://community.amazonquick.com/u/Jose_Siles)\
**Post date:** [April 25, 2023, 6:41am UTC](https://community.amazonquick.com/t/drill-down-one-by-one-in-every-expand-click/12609/3 "2023-04-25T06:41:01Z")

</div>

Hi @Max , thanks for your response!

Alright, we are aligned, because that is what I’ve doing. However, would be perfect if, at anytime, a new feature it’s released, so you can select it in the analsys, to always have it collapsed.

Best,

Jose

---

<div class="post-metadata">

**Author:** ![Jesse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/jesse/32/177_2.png) [@Jesse](https://community.amazonquick.com/u/Jesse)\
**Post date:** [April 25, 2023, 4:51pm UTC](https://community.amazonquick.com/t/drill-down-one-by-one-in-every-expand-click/12609/4 "2023-04-25T16:51:15Z")

</div>

just want to highlight you can also click on the column header to Collapse or Expand the entire column rather than doing 1 by 1.

![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/7/7b71b1eeeb4ac017a4622f79e8fe895aad58f202.png)

---

<div class="post-metadata">

**Author:** ![DeepakS](https://avatars.discourse-cdn.com/v4/letter/d/b2d939/32.png) [@DeepakS](https://community.amazonquick.com/u/DeepakS)\
**Post date:** [April 28, 2023, 5:50pm UTC](https://community.amazonquick.com/t/drill-down-one-by-one-in-every-expand-click/12609/5 "2023-04-28T17:50:53Z")

</div>

Hi @Jose_Siles, Did Max’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community Q&A Forum!