Question abt Cross Tab query

[rishi_375]

Hi,
I write below query..

TRANSFORM Sum([Usage_Cost].[UsageValue]) AS [SumOfThe Value]
SELECT [Usage_Cost].[BYM] AS BYM_Date, [Commodity].[Commodity_Id], format([Usage_Cost].[BYM],'mmm yy') AS [Month]
FROM Usage_Cost, TS_US_Code, Commodity
WHERE [Usage_Cost].[TS_Code]=[TS_US_Code].[TS_Code] And [TS_US_Code].[CommodityId]=[Commodity].[Commodity_Id] And [Usage_Cost].[US_Code] Not In ('EDN','EDC')
GROUP BY [Usage_Cost].[BYM], DatePart('m',[Usage_Cost].[BYM]), [Commodity].[Commodity_Id]
PIVOT [FY];


In PIVOT FY value appear as column i want hide that column in PIVOT which does not have value.
Please help me.
Thanks.