I'm trying to display ONLY the MAX value of the bottom pill's graph before I use dual axis to combine. The end result I'm looking for is for the top graph to have a single point (max point) from the second graph.
Try this on your left continuous measure on the rows shelf:
IF ATTR([Your Measure]) = WINDOW_MAX(ATTR([Your Measure])) THEN ATTR([Your Measure]) END
This basically only shows the measure if it is the max date. You will probably need to use a different aggregate other than ATTR, depending on your what you are doing.
So do I use that in the Create Calculated field then drag it to.....where?
Yes it is a calculated field... See the attached workbook for an example using sales data. version 9.3
