we are trying to find a solution for the following problem statement using hierarchies in Excel Pivot Tables. I hope the excel community can help with solutions or suggestions.