Forum Discussion
Removing Summary Totals from a Query
Thanks for the assistance. I think this solution will only work where I only have one WBS1 value (as in my sample). I actually need a solution that will work if I have MULTIPLE WBS1 values in my table. Is there a simple addition here?
See a larger data sample below.
Anonymous - Any further thoughts on my response above? Appreciate any assistance.
rdraytonNBRS Did you ever resolve this? I have a similar issue and running into the same problems
- Ashish_Mathur
Super User
Hi,
Share some data, explain the question and show the expected result.
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
