Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
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.
Any suggestions?
Thanks for your help!
Vishsaggi,
I have attached some sample data for your review. Thank you for looking at this!
Try this in your straight table calculated expression for dimension primary surgeon like below and check supress when value is null for this calculated dim expr.
= Aggr(IF(Rank(Max(timeProcedureStop))<=2, primarySurgeon), primarySurgeon, timeProcedureStop)