July 14, 2013 at 12:08 pm
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply