Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
sum({<Month = {$(=Maxstring(Month))}>}Sales)
Thank you all