# Cant hide Summarized Calculated Columns in Pivot **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [December 9, 2021, 11:02pm UTC](https://forums.toadworld.com/t/cant-hide-summarized-calculated-columns-in-pivot/54245 "2021-12-09T23:02:20Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![DMP](https://avatars.discourse-cdn.com/v4/letter/d/7ab992/32.png) [@DMP](https://forums.toadworld.com/u/DMP)\ **Post date:** [December 9, 2021, 11:02pm UTC](https://forums.toadworld.com/t/cant-hide-summarized-calculated-columns-in-pivot/54245/1 "2021-12-09T23:02:20Z")
See picture below: 1- In Brio I have a pivot that contains one calculated field. This calculation is the division of two fields in the query. In Brio these two columns have been added to the pivot but I have an option to hide them. There is no need to see these two columns when I only want to see the calculated Utilization. 1. In Toad 5.3 I can make the calculation with the formula shown. This is to work around an error that is fixed in Toad 5.6. But I had to add the two other columns. I cannot hide them. 2. The only thing I can do is remove the columns instead of hiding them. But this breaks the calculation and I get an error. This does not occur if I have a calc that is just adding column values together. I believe this is because I have to use the "Use Summary values" Option. The columns need to be summarized before the calc is applied. **IS THERE A WAY TO HIDE THE COLUMNS IN THIS SCENARIO?** P.S. It looks like the "Use Summary Values" Option is missing in Toad 5.6. Where did it go? P.P.S. In the Brio workbook I am converting, I have 12 pivots with 30+ similar calculated field issues. So it gets pretty hard to read the calculated columns. ![Cant hide summarized calc columns in pivot](https://global.discourse-cdn.com/quest/original/2X/b/baae4795e53555dba803e6ad4ee76a52a8394659.png) ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [December 10, 2021, 5:00am UTC](https://forums.toadworld.com/t/cant-hide-summarized-calculated-columns-in-pivot/54245/2 "2021-12-10T05:00:02Z")
No way to hide columns in the pivot grid that I know of, although I could see a limited use case for it. However, if your MTD fields are already summarized/agg'd, then you don't need to drag them into your pivot if you don't need to see those values... just define your calculation (division expression) but make sure you use the Default Calculation Mode, since your MTD fields are already summed. As your screen snap shows, there is still the "Use Summary Values" calc mode present. ---
**Author:** ![DMP](https://avatars.discourse-cdn.com/v4/letter/d/7ab992/32.png) [@DMP](https://forums.toadworld.com/u/DMP)\ **Post date:** [December 10, 2021, 5:32pm UTC](https://forums.toadworld.com/t/cant-hide-summarized-calculated-columns-in-pivot/54245/3 "2021-12-10T17:32:17Z")
I suppose I could do that but I would have to change a lot of queries. Also, the "Use Summary values" is showing in my screenshot of Toad 5.3 but Toad 5.6 does not have this option. Did they move this option? ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [December 10, 2021, 5:48pm UTC](https://forums.toadworld.com/t/cant-hide-summarized-calculated-columns-in-pivot/54245/4 "2021-12-10T17:48:39Z")
Use Summary Values is still there... my screen snap is from my TDP WB 5.6... ![image](https://global.discourse-cdn.com/quest/original/2X/a/ac7ce6df66fb1af5f21ed1bf5ef28a2e0554707e.png) ---
**Author:** ![DMP](https://avatars.discourse-cdn.com/v4/letter/d/7ab992/32.png) [@DMP](https://forums.toadworld.com/u/DMP)\ **Post date:** [December 10, 2021, 7:18pm UTC](https://forums.toadworld.com/t/cant-hide-summarized-calculated-columns-in-pivot/54245/5 "2021-12-10T19:18:38Z")
It must be Gremlins....I don't have it in Toad 5.6 (32-bit) ![pivot](https://global.discourse-cdn.com/quest/original/2X/b/bad3ef2451f753f8b0a0990dc3583574a5183767.png)