I created an MDX statement which will display this data
-----------------------------------------------------------------------------------------------------------------------
Five Hand Pack Four Hand Pack
-----------------------------------------------------------------------------------------------------------------------
Vacuum Pack | PolyPack | Vacuum Pack | PolyPack
-----------------------------------------------------------------------------------------------------------------------
ABC566rr |ATC | 3,780 | 12,378 | 11,888 | 34,55
---------------------------------------------------------------------------------------------------------

However, I would need to display also the VacuumPack total, the Polypack total and the Overall total. This should be displayed at that the end of the table, like this

---------------------------------------------------------------------------------------------------------------------------------------------------------
Five Hand Pack Four Hand Pack
--------------------------------------------------------------------------------------------------------- | VP Total | PP total | Gran
Vacuum Pack | PolyPack | Vacuum Pack | PolyPack
---------------------------------------------------------------------------------------------------------------------------------------------------------
ABC566rr |ATC | 3,780 | 12,378 | 11,888 | 34,555 | 1234567 |65432 | 65434421
-------------------------------------------------------------------------------------------------------------------------------------------

However, I don't know how I would create an MDX statement that will output this result set. The MDX statement is this

SELECT {FILTER(CROSSJOIN([HAND CLASS].[Hands Name].MEMBERS,[DISTRIBUTION TYPE].[Plastic Type Name].MEMBERs), [Measures].[Qty Box Received] > 0 ) } on columns

{ Filter(CROSSJOIN({ [PACKING HOUSE].[Packing House Name].MEMBERs}, {[BRAND].[Brand Name].members}), [Measures].[Qty Box Received] > 0 ) } on Rows

FROM Pallets WHERE ([Measures].[Qty Box Received],[MARKET].[All MARKET].[Middle East],[VOYAGES].[All VOYAGES].[Al Zohal].[03-01])

How do I add the Mdx statement that will output the totals? Please help.
Any help will be much appreciated
Thanks very much in advance

Maye

Yo can add additional sets to the columns expression, such as

{FILTER(CROSSJOIN([HAND CLASS].[Hands Name].MEMBERS,[DISTRIBUTION TYPE].[Plastic Type Name].MEMBERs), [Measures].[Qty Box Received] > 0 ), crossjoin([Hands Class].[All Hands],[DISTRIBUTION TYPE].[Plastic Type Name].MEMBERs) } on column

HTH
Bria
www.geocities.com/brianaltmann/olap.html