16 Replies Latest reply: Jul 2, 2015 10:53 AM by Srikanth P RSS

    Hide dimensions who are used in acc sum

    Dirk Groen

      Hi there,

       

      I used the folowing expression to accumulate a expression 12 yeamonth values back

       

      =rangesum(above( sum({<CalenderYearMonth={"<=$(=max(Year)&right(0&max(Month),2))"}>}#SalesInvoiceQuantityInKilo),0,12) )

       

      Is it possible to hide the first 12 dimension values.

       

      The set analysis is used to select my calendar with is not connected becasue i have a fiscal and a normal calendar.

       

      Who can help me with this question?

       

      Regards,

       

      Dirk