Forum Discussion
Solved
Analysing Multiple Cells in a Single Field in Pivot Table
Hi all. This is my first post here. I am sorry if I have missed anything. My problem is that I have a few hundred complaint cases on a fleet of buses regarding their maintenance. My task is to an...
penguin_wai , you may add data in columns D and E to data source with some names and show them in hierarchy.
Hi SergeiBaklan
Thanks for your reply. I have tried your method. As shown in the attached, the problems in columns D and E are displayed as the sub-problems of those in column C. Is there a way to display the problems in each cell indepedently and counted in the Grand Total?
SergeiBaklan I have applied power query and successfully solved the problem. Thanks Sergei!
