1 Reply Latest reply on Feb 21, 2013 3:53 PM by Shawn Wallwork

    Trying to create a monthly difference row

    Dennis Kim

      Hi Tableau Pros,

       

      I'm trying to create a separate row independent of my values that lists the current month - previous month difference.  I've create a table calculation by right clicing on the values, but I cannot show it as a separate line item.

       

      Additionally, I'd like to compute the 3 month moving average underneath this row.  Any assistance would be greatly appreciated!

        • 1. Re: Trying to create a monthly difference row
          Shawn Wallwork

          Hi Dennis, there are probably better ways to post an image to these forums than to paste it in an Excel spread sheet. [But this is something my wife would absolutely do! So I understand the mentality.] It looks as if your data is sensitive, so might you be able to use the Super Store data to mock up something similar to what you're trying to accomplish? Doing current month minus previous month can be easily done, but there are lots of factors in play. Hope to hear back from you.

           

          --Shawn