0 Replies Latest reply on Feb 27, 2012 11:35 AM by dean.rice

    Sum Where Current Month

      I'm just getting started in Tableau, probably a basic question. I need to create a table with four measure columns for just one dimension.

       

      Market, Current Month Volume, % Chg from Previous Month, % Chg from Previous Quarter, % Chg from Previous Year

       

      For Current Month Volume I'd like..

       

      Sum(Volume) where month = max(month)

       

      For %chg from previous month I want to essentially say..

       

      Sum(Volume) where month = max(month) / Sum(Volume) where month = max(month) - 1  (you get the idea, usually use AddMonths - 1)

       

      I'm still trying to do this, but given a deadline thought I'd reach out.. thanks.