I am fine doing this in graphical form, text form, reference line or anything. But I cannot figure out a way to do it except by putting a max reference line on. But I need the best week for sales YTD, which often is not on the graph so the reference line wont use it as the max.
3 of 3 people found this helpful
Use This Calc
and Drag it to Filter and Select TRUE.
Make a calculated field: max sales:
Put it in filter, select true.
You will get it.
Hope it helps.
max.twbx 1.2 MB
Thanks Deepak! That worked perfect
And Michael! That was it as well!