Sum of Rows

[rkspareek1992]

Hi,

My expression is:

Sum({<LinkDate={'<=$(vDate)'}>}TSL)*only({<Date_Currency={'$(vMaxCurrencyDate)'}>}Rate_Currency1)

and I am  not getting sum of expression.

vDate is DataIland Date,

only({<Date_Currency={'$(vMaxCurrencyDate)'}>}Rate_Currency1)

is for selected Date_Currency and by default should show rate of max of Date_Currency.

Kindly suggest change in my expression.

[rkspareek1992]

I have just one dimension in straight table is RBUKRS.

[sunny_talwar]

Can you try this

Sum(Aggr(Sum({<LinkDate={'<=$(vDate)'}>}TSL)*only({<Date_Currency={'$(vMaxCurrencyDate)'}>}Rate_Currency1), RBUKRS))

[rkspareek1992]

Hi Sunny,

I have already tried, but unable to get sum.

[sunny_talwar]

Would you be able to share a sample?

[rkspareek1992]

I am using pivot table and unable  to sum values..