5 Replies Latest reply: Jan 6, 2016 10:15 AM by Marcus Sommer RSS

    Pivot Table - Errors in calculated Dimension

    Jim Chan

      Hi guys,

       

      I have create a calculated dimension. Although it says - Expression is OK, and the value is correct.

       

      But y is it say - error in calculated dimension??????

       

      My calculated dimension is  =sum({<YYYY={$(=year(today()))},KPI_DATE={'$(=upper(Month(today())))'}>}count).

       

      how can i label this calculated dimension as Current Month?

      error.png

       

      rgds

       

      Jim