Forum Discussion
Removing Summary Totals from a Query
Afternoon All, I have a query of a data table that contains both the individual line item values, along with the summary values of the lower level line items in the one table. See the screenshot ...
Hi,
Similar to the original post; I have a WBS Hierarchy with summary rows of the lower levels. I have not been successful in using the above technique to properly remove the summary rows and could use some help on how to modify it. Sample data below, I have hundreds of projects with varying levels of WBS hierarchy and inconsistent naming nor any parent child relationship table.
Sample data below. I need to remove the highlighted rows since those are sums of the children. Any help is appreciated, thanks.
| Contract ID | Contract Name | WBS.1 | WBS.2 | WBS.3 | WBS.4 | Fee | WBS Nesting | Sort Order |
| 2020.01 | Project 1 | Project 1 | null | null | null | $ 14,000.00 | 0 | 1 |
| 2020.01 | Project 1 | Task Order 1 | null | null | null | $ 14,000.00 | 1 | 3 |
| 2020.01 | Project 1 | Task Order 1 | PC Coordination | null | null | $ 14,000.00 | 2 | 4 |
| 2020.01 | Project 1 | Task Order 1 | PC Coordination | Meetings and Coordination | null | $ 7,000.00 | 3 | 5 |
| 2020.01 | Project 1 | Task Order 1 | PC Coordination | Meetings and Coordination | Sub-Meeting Coordination | $ 7,000.00 | 4 | 6 |
| 2020.01 | Project 1 | Task Order 1 | PC Coordination | Cost Estimating | null | $ 7,000.00 | 3 | 7 |
| 2020.01 | Project 1 | Task Order 1 | PC Coordination | Cost Estimating | Design Estimates | $ 7,000.00 | 4 | 8 |
| 2022.01 | Project 2 | Project 2 | null | null | null | $ 972,100.00 | 0 | 1 |
| 2022.01 | Project 2 | Task Order 1 - CO | null | null | null | $ 162,100.00 | 1 | 2 |
| 2022.01 | Project 2 | Task Order 1 - CO | General Contract Management | null | null | $ 800.00 | 2 | 3 |
| 2022.01 | Project 2 | Task Order 1 - CO | Program Management | null | null | $ 500.00 | 2 | 6 |
| 2022.01 | Project 2 | Task Order 1 - CO | Program Support | null | null | $ 800.00 | 2 | 10 |
| 2022.01 | Project 2 | Task Order 1 - CO | PM Training | null | null | $ 60,000.00 | 2 | 14 |
| 2022.01 | Project 2 | Task Order 1 - CO | PM Training | PM Training Level 1 | null | $ 60,000.00 | 3 | 15 |
| 2022.01 | Project 2 | Task Order 1 - CO | PMO Support | null | null | $ 100,000.00 | 2 | 22 |
| 2022.01 | Project 2 | Task Order 2 | null | null | null | $ 95,500.00 | 1 | 35 |
| 2022.01 | Project 2 | Task Order 3 | null | null | null | $ 54,000.00 | 1 | 39 |
| 2022.01 | Project 2 | Task Order 4 | null | null | null | $ 200,000.00 | 1 | 44 |
| 2022.01 | Project 2 | TO5 - 3 Year Program | null | null | null | $ 90,000.00 | 1 | 47 |
| 2022.01 | Project 2 | TO5 - 3 Year Program | General Contract Management | null | null | $ 4,000.00 | 2 | 49 |
| 2022.01 | Project 2 | TO5 - 3 Year Program | Program Management | null | null | $ 76,000.00 | 2 | 53 |
| 2022.01 | Project 2 | TO5 - 3 Year Program | PM Training | null | null | $ 10,000.00 | 2 | 62 |
| 2022.01 | Project 2 | TO6 | null | null | null | $ 70,500.00 | 1 | 65 |
| 2022.01 | Project 2 | Task Order 7 | null | null | null | $ 300,000.00 | 1 | 70 |
Ashish_Mathur
Super User
Super UserHi,
I do not see any pattern there at all. So i do not know which filter condition can be applied to remove the grey coloured rows.
No filters, was able to accomplish with transformations and some If statements.