Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.