don't want to display "Operation type" in my pivot table

Sadeesh Narendran
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 9, 2021

Hi, 

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.

 

pivot table setting.JPG

Is there a way to do it permanently? Any help is appreciated!

I tried editing the settings but its not working

Thanks!

4 answers

1 accepted

3 votes
Answer accepted
Katerina Kovriga _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 11, 2021

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.

Sun 1-1.png

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:

Sun 1-2.png

SELECT T1.'Status', T1.'Count' AS 'Whatever name you want'
FROM T*

Sun 1-3.png

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.

Sadeesh Narendran
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 12, 2021

@Katerina Kovriga _Stiltsoft_ Thanks Katerina! Here again when I use SQL i get all listed duplicate items, but I want the rows to be merged something like below.

 

Table in Confluence.JPG

Katerina Kovriga _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 12, 2021

Hi @Sadeesh Narendran ,

Please try the following option: wrap your Pivot Table into the Table Filter macro.

Here is your two-dimensional pivot:

Mon 4-1.png

Now you go the the Table Filter macro settings -> Filters tab and check the Hide columns option:

Mon 4-2.png

And navigate to the Filtration tab -> Set filters' default values and choose the last column which you want to hide:

Mon 4-3.png

So, the structure of your pivot table will be preserved.

Sadeesh Narendran
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 13, 2021

@Katerina Kovriga _Stiltsoft_  Thanks for your step by step explanation. I did followed all your steps but Im not getting that column "Literal of Release Date" to hide.

 

Literal Capture.JPG 

Katerina Kovriga _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 13, 2021

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.

Sadeesh Narendran
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 13, 2021
Katerina Kovriga _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 13, 2021

Please update the app and check if the issue is still present.

If yes, then create a support request - I've warned our support team about the issue.

Sadeesh Narendran
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 13, 2021

@Katerina Kovriga _Stiltsoft_ Thanks for all your help! Unfortunately its my corporate App, I cant upgrade. I will raise the request internally.

 

Thanks for ur help!

Arun M
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 17, 2023

Hi Team

Please update on Above issue , I am facing similar situation . Would like to rename the columns (Sum of), But not seeing any options for renaming or Hide the columns . 

1 vote
Katerina Rudkovskaya [Stiltsoft]
Atlassian Partner
July 19, 2023

Hi @[deleted],

To rename the columns, you’ll need to wrap your Pivot Table macro in the Table Transformer macro.

On Confluence Server/Data Center you can do it directly and on Confluence Cloud you need the Table Toolbox macro to nest macros.

To hide unwanted columns, use the Table Filter macro on top. The “Hide column” option was moved to a different place in the new macro UI.

Please check the screenshot below:

Tue 11-1.png

Click on the Add filter button, choose the Hide columns filter type, and hit the Add button.
Now simply add the columns that you want to hide:

Tue 11-2.png

Hope it helps your case.

0 votes
Deleted user May 19, 2022

Thanks @Katerina Kovriga _Stiltsoft_ the amazing thread above. I am facing one issue after following the above all the instructions. 

my setup -

  1. I am merging two tables
  2. creating pivot
  3. filtering that table

but I am not able to get expected. 

 

  • 2 tables => 

2022-05-19 22_08_46-Mouse Highlight Overlay.png2022-05-19 22_08_56-Mouse Highlight Overlay.png

 

and after following the above all instructions I reached at this output 

but want to hide the Name column (red arrowed) . 

2022-05-19 22_09_08-Mouse Highlight Overlay.png

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 .
 

2022-05-19 22_09_51-Mouse Highlight Overlay.png

Is it some issue or I am missing something. ?

Katerina Kovriga _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 19, 2022

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.

Katerina Kovriga _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 20, 2022

I can suggest such settings for your case:

Fri 8-1.png

Fri 8-2.png

Fri 8-3.png

Fri 8-4.png

Seems that the result table looks exactly as you need.

Deleted user May 20, 2022

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_ ⚡ 🤘 . 

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 11, 2021

What are you using to create this table, and from where is it drawing its data?

Andrey Khaneev _StiltSoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 12, 2021

It is the Pivot Table macro from the Table Filter and Charts app.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events