Hello,

I have a very simple query where I'd like to remove a column. The query is:
select {[Measures].[Transaction ID]} on Columns,
ORDER([Products].[SDP].[SeniorGroup].[ProductGroup].Children,
[Measures].[Transaction ID], DESC) on Rows from ProductToProductCube

This query returns:
Col1;Col2;Col3
ProductGroup;Child1;29
ProductGroup;Child2;932
ProductGroup;Child3;394
ProductGroup;Child4;29

However, I'd like to remove the ProductGroup column and have it return (to
work with the other existing queries):
Col1;Col2
Child1;29
Child2;932
Child3;394
Child4;29

Is there an easy way to do this?