C
Cristiano Moraes da Silva
Hi,
I want to Count the number of child under a CustomGroupMember.
At first, i tried the MDX-function 'Count', but it doesn't work and result
0.
=======================================================
Total = PivotTable.ActiveView.AddCalculatedTotal('2', 'COUNT',
'Descendants([Bairros].CurrentMember,
[Bairros].[Unidade]).Count', 2)
PivotTable.ActiveView.DataAxis.InsertTotal(Total,
PivotTable.ActiveView.DataAxis.Totals.Count)
Field = PivotTable.ActiveView.FieldSets(0).AddCustomGroupField('Teste1',
'Bairros', 0)
vMembros = GetBestBairros ' Return an array of members to group!
Field.AddCustomGroupMember('All Bairros', vMembers, 'My Group')
=======================================================
Thanks
Cristiano
===========================================
Cristiano Moraes da Silva
SIG Soluções em Informática e Gestão LTDA
Santa Maria - RS - Brasil
(e-mail address removed)
www.sigbrasil.com.br
+55 552268699
I want to Count the number of child under a CustomGroupMember.
At first, i tried the MDX-function 'Count', but it doesn't work and result
0.
=======================================================
Total = PivotTable.ActiveView.AddCalculatedTotal('2', 'COUNT',
'Descendants([Bairros].CurrentMember,
[Bairros].[Unidade]).Count', 2)
PivotTable.ActiveView.DataAxis.InsertTotal(Total,
PivotTable.ActiveView.DataAxis.Totals.Count)
Field = PivotTable.ActiveView.FieldSets(0).AddCustomGroupField('Teste1',
'Bairros', 0)
vMembros = GetBestBairros ' Return an array of members to group!
Field.AddCustomGroupMember('All Bairros', vMembers, 'My Group')
=======================================================
Thanks
Cristiano
===========================================
Cristiano Moraes da Silva
SIG Soluções em Informática e Gestão LTDA
Santa Maria - RS - Brasil
(e-mail address removed)
www.sigbrasil.com.br
+55 552268699