1 Reply Latest reply on Oct 29, 2018 8:02 AM by Alyssa Ashton

    Month and year totals same chart

    Alyssa Ashton

      Hello,

      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?

      Thanks!