Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
can someone help me?
if i insert "sum(Quantity)" i get always the sum of all selected FYs. Any idea how that could work?
Many thanks for any help!
Best Markus
I think you mean this
Sum({<year = {"$(=max(year))"}>} Quantity)
Sum({<FY = {"$(=max(FY))"}>} Quantity)
maybe this:
sum( {< year = {"=max(year)"} >} Quantity )
I hope it helps.
thanks for your reply Andrea! Unfortunately your suggested formular gives the same results as sum(Quantity)
did you try with this below ?
sum( {< FY = {"=max(FY)"} >} Quantity )
FY field should be an external filter and not a pivot dimension.
yes i changed year to FY
I think you mean this
Sum({<year = {"$(=max(year))"}>} Quantity)
Sum({<FY = {"$(=max(FY))"}>} Quantity)
Thank you Sunny and Andrea!!