FirstSortedValue and total in a pivot

[p_andreev]

Hi everybody,

Could someone help with the following issue:

I have this expression -

Rangesum(FirstSortedValue({$<Year=,Month=, Day=, ItemAndDayYearMonth={"=$(=Max({$<ItemAndDayYearMonth={'<=$(=Year(Max(Date))*100+Num(Month(Max(Date))))'}>} ItemAndDayYearMonth))"}>} ItemCostValue/Rate,-Date))

and I can't get a total on this column in a pivot. Is the problem in FirstSortedValue or Rangesum function ?

[tresB]

Remove rangesum(), and try like:

FirstSortedValue({$<Year=,Month=, Day=, ItemAndDayYearMonth={"=$(=Max({$<ItemAndDayYearMonth={'<=$(=Year(Max(Date))*100+Num(Month(Max(Date))))'}>} ItemAndDayYearMonth))"}>} ItemCostValue/Rate,-Date)

[p_andreev]

Yes, I have tried this and unfortunately it does not work.

[tresB]

Can you share your sample qvw?

[p_andreev]

tresesco, thank you for your willingness to help.

I found a solution including the above expression in Aggregation at the lowest level of the dimensions.

Have a nice day.