# Pivot Subtotals **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [June 26, 2019, 3:47pm UTC](https://forums.toadworld.com/t/pivot-subtotals/46896 "2019-06-26T15:47:09Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![steve.robinson](https://avatars.discourse-cdn.com/v4/letter/s/eb8c5e/32.png) [@steve.robinson](https://forums.toadworld.com/u/steve.robinson)\ **Post date:** [June 26, 2019, 3:47pm UTC](https://forums.toadworld.com/t/pivot-subtotals/46896/1 "2019-06-26T15:47:09Z")
Running TDP workbook 5.0.6.95 and have a question about subtotals. In the pivot below, the user wants to have subtotals for PROJ\_GROUP but not for PROJ\_ID. For the PROJ\_GROUP "ELIMN" it's currently showing a PROJ\_ID subtotal but not a PROJ\_GROUP subtotal. I assume this is because there is only 1 PROJ\_ID in the PROJ\_GROUP "ELIMN" and therefore the PROJ\_GROUP and PROJ\_ID subtotals would be the same. However, since the user wants to only show subtotals for PROJ\_GROUP, if the subtotals for PROJ\_ID are eliminated then there will be no subtotal for the PROJ\_GROUP "ELIMN". Is there any way to show subtotals even if there is only 1 item in the group? ![pivot%20subtotals](https://global.discourse-cdn.com/quest/original/2X/2/2b2cb1f8901c916ba53ebabe87200dd7dceddaae.jpeg) ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [June 27, 2019, 8:34pm UTC](https://forums.toadworld.com/t/pivot-subtotals/46896/2 "2019-06-27T20:34:38Z")
We are still looking into this. Stand-by ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [June 27, 2019, 8:38pm UTC](https://forums.toadworld.com/t/pivot-subtotals/46896/3 "2019-06-27T20:38:04Z")
Actually if this data is not sensitive can you export to excel the underlying dataset and send to me? It will be faster for us to replicate and look at your use case. [debbie.peabody@quest.com](mailto:debbie.peabody@quest.com) ---
**Author:** ![Cindy.Sang](https://avatars.discourse-cdn.com/v4/letter/c/edb3f5/32.png) [@Cindy.Sang](https://forums.toadworld.com/u/Cindy.Sang)\ **Post date:** [June 28, 2019, 8:25am UTC](https://forums.toadworld.com/t/pivot-subtotals/46896/4 "2019-06-28T08:25:38Z")
QAT-14998 is created to evaluate if TDP could like Excel, add subtotal even only 1 item. ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [July 10, 2019, 3:21am UTC](https://forums.toadworld.com/t/pivot-subtotals/46896/5 "2019-07-10T03:21:54Z")
We fixed this by adding an option. By default it will display as it does now. But you will be able to set an option to change this. Enhancement in TDP 5.0.7