2 Replies Latest reply on Aug 27, 2018 8:44 AM by Ian Armstrong

    Isolating values tied to specific dates

    Ian Armstrong

      Hi all,

       

      I'm trying to make a cross tab with some line charts/sparklines incorporated in.

       

      I want to show sparklines for three measures (Discount, Profit, and Profit Ratio).  I also want to show the prior year (2015) and current year (2016) values in text/crosstab format for each of these measures across each of the subcategories (see red text in attached image for the desired outcome).

       

      I can't figure out how to 1) isolate the "prior" and "current" values for each measure, and 2) display them in a single "prior" and "current" column.

       

      Any help you can provide will be hugely appreciated.  Thank you!

       

      Note -- the red numbers in the picture below are gibberish and were just randomly punched in to show the general effect I'm looking for.

       

      example of desired outcome.png