I am building a pivot table report which is taking initiatives by status and product.
Question: Is there a way that I can flatten the products to product lines when some of my product lines contain product lines.
e.g. Consider this hierarchy
I would like to generate a pivot that shows two rows, one each for Product Line A and Product Line B, but contains all initiatives from all Product Lines and Products within.
This would be beneficial to large product organisations who are looking to roll-up a products and product lines into a master product line report
|Release time frame|