Rangesum before total is not coming

[infosense_devel]

Hello,

I have a pivot table, in which there are three dimension like SBU, Territory, Salesperson and month (month has partial sum ticked in Presentation tab)

and there are some expressions like MTD,PYTD,MTD VS MTD % and YTD vs PYTD%

I have pick up Month dimension and pivoting it in rows like below:

In YTD Vs PYTD % I have applied expression as per below and its result comes fine

but when I see into Total column its shows me dash '-' like below:

If anyone have any idea about these problem.

Please help me to resolve it.

Thanks.

[marcus_sommer]

Maybe you need an aggr() around your expression like:

sum(aggr(YourExpression, Dim1, Dim2, ...))

- Marcus