RangeSum expression with Grand total for Dimension.

[infosense_devel]

Hello All,

i have scenario where i have pivot table with two dimension and one expression.

in expression we are using Rangesum()  as per below.

=RangeSum(Before(Sum({<Common_Month = ,REC_TYPE = {InvoiceDateRec}>} (RAGLDA_ACCTD_AMOUNT * XRATE_CONST * RATE)), 0, ColumnNo()))

my table layout is as per below.

I need Month Wise total column at right side of the table.

i have checked "Show partial Sum" check box on "presentation" tab of property, but still i am not able to see column wise total.

thanks in advance.

[sunny_talwar]

Isn't the Jun value (in the above screenshot) the total value you would see?

[infosense_devel]

i have presented my issue by simplifying it.

but assume that if i have requirement to show total column at right side of my total then?

can we achieve it with rangesum() in expression?

[sunny_talwar]

Not entirely sure it would show, bit it can be done using Dimensionality() function.

How to use - Dimensionality()‌

The second dimension... or how to use secondarydimensionality()