I presently have a table displaying patient counts with year, quarter, month on the Columns, Name on the Rows. I have a calculated field showing the change from month to month, (ZN([Patient_Count]) - LOOKUP(ZN([Patient_Count]), -1)) / ABS(LOOKUP(ZN([Patient_Count]), -1)). I would also like to display total patient counts by year, with the year over year change. Is there a way I can do this all on the same viz?
OK, would there be a way to allow the user to choose if they want to view by month or year?