I am trying to create a pivot table in that I don't want to display "Operation type" (Sum / Count/ Average / Literal) in my pivot table.
I want to remove Operation type in my pivot table view.
Is there a way to do it permanently? Any help is appreciated!
I tried editing the settings but its not working
Hi @Sadeesh Narendran ,
We can suggest hiding the whole pivot panel into the view mode: go to the Pivot Table macro settings -> Options tab -> Hide control panel.
If you want to organize your result pivot table into a better way, you may rename its Operational type column - wrap your Pivot Table macro into the Table Transformer macro and use the following SQL query:
SELECT T1.'Status', T1.'Count' AS 'Whatever name you want'
If you don't want to show this column in the result table at all, just don't list it in you SQL query. For example, "SELECT T1.'Status' FROM T*" will publish only the first "Status" column.
Hope it may help your case.
Hi @Sadeesh Narendran ,
Please try the following option: wrap your Pivot Table into the Table Filter macro.
Here is your two-dimensional pivot:
Now you go the the Table Filter macro settings -> Filters tab and check the Hide columns option:
And navigate to the Filtration tab -> Set filters' default values and choose the last column which you want to hide:
So, the structure of your pivot table will be preserved.
Hi @Sadeesh Narendran , it's a strange situation - if you see the column into the Pivot Table macro, it should be also visible via the Table Filter macro.
So, please, check the version of your app - the current one is 7.6.5.
And raise a support request here. Please attach your page storage format: upper right corner of the page > menu ... > View page storage format.
Thanks @Katerina Kovriga _Stiltsoft_ the amazing thread above. I am facing one issue after following the above all the instructions.
my setup -
but I am not able to get expected.
and after following the above all instructions I reached at this output
but want to hide the Name column (red arrowed) .
and when I tried to do the same via hiding that column .
it makes it shown as below. the team1 table header label is gets missed .
Is it some issue or I am missing something. ?
Seems that your Pivot looks not like mine, please attach a screenshot of the Pivot Table macro settings. It seems that you use the Name column twice and get a kinda strange aggregation: first in one column, than in two columns divided by teams.
And again in the initial example you should hide the Literal of Name column. So, maybe give a structure of the result table that you want to achieve.
Oh My god! My expectation was different but this is superb and amazing and much better Katerina Kovriga _Stiltsoft_ .
I was trying to make each team member name in different rows actually and spent some hours, but I guess that is not possible 😇
But this is really amazing and simple to go ahead with ✔ .
Thank you @Katerina Kovriga _Stiltsoft_ ⚡ 🤘 .
Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋♀️ ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events