5 Replies Latest reply: Jan 14, 2015 6:52 AM by Jyothi K V RSS

    calculated dimension.

    Jyothi K V

      Hi All,

       

      we have created a straight table with one dimension called month and 8 expressions.

      requirement was to display only one month in the table.

      so we selected Max Number (1-100) to 1 in the presentation tab. by default it displays only Jan when no selection is made on month. when clicked on different months it changes accordingly.

      but the user wants to see the previous month values by default.. which should be December when i see in January.

      so i tried modifying the dimension with the help of calculated dimension. its not giving expected results when no selection is made on month.

      below is the calculated dimension.

      =if(GetSelectedCount(Month)=0,Month(AddMonths(MonthStart(Today()),-1))),Month)

       

      please help. any suggestions appreciated.

       

      Thanks

      Jyothi