Sum only for the maximum of selected Months

[#1]

Hello to all! I need help with the following: I am trying to make an expression in pivot table to display the total sales only for the maximum month over the selected months. More specifically, if the user selectes Jan, Feb, March , the expression will bring sum(sales) of March.Can anyone help?

[Miguel_Angel_Baeyens]

Hi and welcome!

Something like the following should work, assuming there is a field named "Month" and the values are numeric:

Sum({< Month = {$(=Max(Month))} >} Sales)

Hope that helps.

Miguel

[NZFei]

sum({<Month = {$(=Maxstring(Month))}>}Sales)

[#4]

Thank you all