I'm trying to figure out a way to show only the last two procedure stop times by primary surgeon and for an admit date in a chart (straight table or pivot) and I'm having trouble coming up with a solution. Here is what my data looks like currently:
I only want to display those rows that have the highlighted timeProcedureStop column in my final chart. The above data only shows two surgeons and one admit date, but there will be multiple surgeons and admit dates on the final chart.
If you using straight table you have Dimension limits tab in chart properties where you can give largest 2 for your timeprocstop field. IF you are using pivot you might want to write and calculated dimension like