Group By MDX for YTD

• venkyzrocks

  SSCommitted

  Points: 1907

  More actions

  October 15, 2013 at 3:26 pm

  #144643

  HI,

  I'm New to MDX querying, so looking for some help here :

  This is the query that got generated out of profiler :

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

  { [Period].[Jun], [Period].[Jul] },

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

  ON 0 ,

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

  FROM [TFA_Budget2]

  WHERE ( [Measures].[Value])

  201420142014201420142014201420142014201420142014

  JunJunJunJunJunJunJulJulJulJulJulJul

  ABCDEFABCDEF

  10ABCD102030405060102030405060

  Result Set

  201420142014201420142014

  TotalTotalTotalTotalTotalTotal

  ABCDEF

  10ABCD20406080100120

  So we total sum(A) for Jun and JUly and put it in Total.

  Thanks in advance.

• kupy

  SSCommitted

  Points: 1652

  More actions

  October 16, 2013 at 3:32 am

  #1658826

  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])