Hi,

Try something like this

With Member [Period].[Total] as ( [Period].[Jun] + [Period].[Jul])

SELECT CROSSJOIN( { [Fiscal_Year].[2014] },

{ [Period].[Total] },

{ ADDCALCULATEDMEMBERS([Function].[All Function].Children) })

ON 0 ,

NON EMPTY CROSSJOIN( { [Fund].[10]}, { [Account_Code].[ABCD] }) ON 1

FROM [TFA_Budget2]

WHERE ( [Measures].[Value])