Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Why don't you use the Pivot table
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.
"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
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