Creating a collapsible table in Qlik Sense?

[#1]

Hello Everyone,

I am working on a table that should be collapsible ,but I am not able to find any extension to support such functionality.

It would be of really great help if anyone of you can provide some insights regarding same.

Below is the excel snippet of my data and desired output for better understanding.

Datasource

Desired Output

Thanks in advance

[robert99]

Hi

Why don't you use the Pivot table

[#3]

Thanks for the reply @Robert Hutchings

Actually pivot is giving me option something like this, but I want different hierarchy, and also the calculation I am unable to do.

[robert99]

"but I want different hierarchy,"

Unsure what you mean?

"calculation I am unable to do."

It might be best to start another thread on this

[giakoum]

You need to fix your data model a little.

You have New Joinee or Resigned/Retired as measures. If you change them to dimensions with a common field as measure. Then the pivot will look great