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

    Hide dimensions who are used in acc sum

      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?