.NET SDK GetTable and Totals

[#1]

Hi,

I'm connecting to a Sense App using the .NET SDK, and getting tabular data by calling the ISheet member CreateTable, passing in a random string and table properties as parameters.

The table properties has a HyperCubeDef of a dimension and measures, and a parameter of type TableTotals:

Totals = new TableTotals
{
     Position = TableTotalsPosition.Top,
     Label = "Totals",
     Show = true
}

I get data out from the table using the GetTable method and then calling GetData.

I'd like to also get the totals, and I have done so using this after calling GetTable(...):

var grandTotalCells = table.GrandTotalRow;

In my app, I have 4 table cells and 2 totals cells.  How do I know for which table cell the total cell corresponds? (so are the totals relating to cell 1, cell 2, or something else?)

ALSO:

In Sense, I am able to set a 'totals function' - how can I use this in code?

Thanks and regards,

Shane.

[#2]

Hi,

The total cells are in the same order as the measures in the hypercube.

The "totals" is a custom property. Set the function in myTable.Property.Totals.Label and you will

have the result in myTable.Totals.Label.

Best Regards

Lars-Göran Book

[#3]

Hi,

is that kind of thing possible with the CreateTable/GetTable method calls?  Or do I need to take another approach?

A code sample would be a fantastic help

Thanks,

Shane.