2 Replies Latest reply on Jun 20, 2016 7:58 AM by Ewen Witte

    Running_sum in Combination Look up

    Ewen Witte

      Dear Tableau Community!

       

      I want to show the current year running profit against the previous year running profit in a table.

      I expect to see the this years and last years running profit per date and per region with subtotals over region.

       

      In my database, I just have 1 measure column for profit. As a result I used a running sum to populate the running profit for this year and a Lookup calculation to populate the previous years profit.

       

      Sadly this way the subtotals of the year before are not shown. Is there away to make it happen without changing the data source?

       

      Expected result should like this (photo has been editied for illustration - I was not able to compute this values!)

      problemberechnung.png

      Example workbook based on superstore data attached