5 Replies Latest reply on Jan 20, 2016 8:23 AM by Shinichiro Murakami

    Crosstab for multiple measures on several columns: today, yesterday, a week ago

    Bogdan Pop

      Hi,

       

      This is my first post, I hope I am writing this in the proper place.

       

      I am trying to create a quick overview of several measures, and show the values for each KPI on three columns: Today, Yesterday, A week ago. In the attached workbook you'll find my "progress" (not much to speak of), and below you'll find the expected output.

       

      I created 3 calculated fields named (one for each day on the column) - if I add 'Today' on the columns shelf it seems to work, however adding a second field does not generate an extra column.

      Note that 'Today' actually means the last day available in the data (an internal convention if you will), so the calculated field is computed as such.

       

      Expected output:

      Today (1/19/2016)Yesterday (1/18/2016)A week ago (1/12/2016)
      Revenue517709704
      Profit15516684
      Total_Clients495350

       

      I searched for similar workbooks, but most of the examples I found had measures names as columns instead of rows. Can this be achieved ?

       

      Thank you,

      Bogdan