2 Replies Latest reply on Jun 8, 2018 7:25 AM by Shinichiro Murakami

    Showing YTD and Full Year on same table.

    Eleonor Hellblom



      I have a table/view where the user have a parameter to choose Year/Quarter/Month/Week aggregation and then different measured values on the rows, together with a dimension.

      The measured values are shown Full Year, but my user now also wants to see YTD next to them for the previous years in order to correctly compare them - but I don't understand how I get them on the same table? It is also only for the Year Breakdown they want to see this.


      Does any one have an idea on how to do this or a good work around? I have attached a workbook to show. (I excluded some months in the Superstore data so it is until June 2016 and not full year.)


      Thank you in advance!