3 Replies Latest reply on Jan 13, 2017 12:20 PM by Jim Dehner

    Date Calculation based on Year

    Teresa Wright

      My data includes a dimension called "Statement Month/Year" and a measure called Expenses.  I would like to create a line chart similar to the one shown below.  I know I need to extract the year from the date field to create a table calculation, but am not sure how to go about it.  Can't share my workbook due to security reasons.

       

      Expenses By Month.jpg

      Including screen shot of my dimension/measure and also of the Statement Month/Year and Expenses fields from the Data Source page.

      shot 3.jpg    shot 4.jpgshot 5.jpg