Cross table sorting not working
I have a cross table with 4 columns, Dept./Sub Dept/Item Code/Item Name - it shows 4 weeks of sales, and WoW movements. When I try and sort by WoW movement for a given week ignoring hierarchy, it works. When I try and sort including hierarchy, it reverts to default sort, even though the sort parameters still match my choice.
This issue goes away when i remove the Item Name field (not when i remove any other fields)
Is this a known bug? or am i doing something stupid? Thanks all!