Count Columns

• pedro.j.manuel

  Mr or Mrs. 500

  Points: 578

  More actions

  July 14, 2013 at 12:08 pm

  #395138

  Hi hi have a follow result on my mdx query

  groupA | groupB | groupC | TOTAL

  100 200 400 3

  ihi already made the groups, but i don't know how can i count my columns TOTAL

  as you can see on result . but only present if there is values

  with

  member GroupA as Sum({[d P].[ID P].CurrentMember}*[d Condition Type].[Code].&[A01],[Measures].[f Validated Condition Count])

  member GroupB as Sum({[d P].[ID P].CurrentMember}*[d Condition Type].[Code].&[B01],[Measures].[f Validated Condition Count])

  member GroupC as Sum({[d P].[ID P].CurrentMember}*[d Condition Type].[Code].&[C01],[Measures].[f Validated Condition Count])

  member Total as COUNT([d P].[ID P],[d Condition Type].[Code].&[A01])

  //COUNT(,

  // {[d Condition Type].[Code].&[A01],,

  // [d Condition Type].[Code].&[B01],

  // [d Condition Type].[Code].&[C01]

  )

  SELECT {GroupA,GroupB,GroupC,Total} on 0

  FROM [Cube2]

  Can you help me... it will be greatful

  thks