Unable to group columns in pivot table

Originally Posted by NeedForExcel

Hi,

I don't think you can do that with Pivot Tables they way you are trying.

You will have to add a Helper Column to you data, and similar to the Column TL, you will need a corresponding column where you will mention (Using formula or otherwise) the OM.

Then you will have to use that column instead of TL

File attached for reference

Thank you! It actually solved my problem. But, may I know why I can't group those columns? I tried josephteh's reply (pulling the TLs to rows), but it didn't work either.