Total column show

[fabiano]

3 dimension:

D1
+D2
+D3

I need total show columns in D2 or D3 with and without filter by user.

tanks.

[AlexZencovich]

Please describe your questions little detail. There is no way to provide help if I cannot understand what you ask

[fabiano]

Dimension D1
Dimension D2

-Value D1 - 05
.........Value D2 - 01
.........Value D2 - 02
.........Value D2 - 03
- Value D1 - 06
.........Value D2 - 02
.........Value D2 - 03
.........Value D2 - 04
.........Value D2 - 06

Total rows D2 in D1 05 = 03
Total rows D2 in D1 06 = 04

If user filter D2 with > 02 then

Total rows D2 in D1 05 = 01
Total rows D2 in D1 06 = 03

I need show this totals of row in D2 for users.

tanks.

[AlexZencovich]

You need to use OnGetVellValue event to replace cell value with your own count.
Use PCX.MapGetCellInfo to get information about number of cells in inner dimension

[fabiano]

I dont find MapGetCellInfo in object pivotcube.

[AlexZencovich]

Sorry, it must MapGetRowCellInfo and MapGetColumnCellInfo

See details here
http://pivotcube.com/forum/viewtopic.php?t=24

[fabiano]

Ok good option, but:

onrowheaderdbclick parameters (x,y) no equal MapGetRowCellInfo parameters (CellIndex and DimIndex).

I need click in row header (onrowheaderdbclick) and see row total (MapGetRowCellInfo).

Or another suggestion.

[fabiano]

No suggestion for this problem?

[AlexZencovich]

Sorry no. I will add way to solve problem in next build (in few days).
It will require to use Cell.Position parameter as index (that property does not accessible in PivotCubeX now, but I will add access)

[fabiano]

Tanks,

The component is excellent, and the wonderful support.