Comments on: Between and Member Searching ../../../../2012/01/between-and-member-searching/ XLCubed Blog Fri, 04 Jan 2019 14:37:31 +0000 hourly 1 https://wordpress.org/?v=5.3.21 By: xlcubedblog ../../../../2012/01/between-and-member-searching/#comment-228 Thu, 06 Aug 2015 15:12:10 +0000 http://blog.xlcubed.com/?p=3231#comment-228 Hi Errol,

Check out another one of our blogs which will help you achieve this.

You could combine Between and Member Navigate to get a 12 week range.

http://blog.xlcubed.com/2013/07/current-and-previous-month-reporting-made-easy/

The XLCubed Team

]]> By: Errol ../../../../2012/01/between-and-member-searching/#comment-227 Wed, 05 Aug 2015 17:01:22 +0000 http://blog.xlcubed.com/?p=3231#comment-227 I would like to see how to filter by something like the most recent 12 months or the most recent 12 weeks, to whatever date the report is run. I need it to be dynamic using current date.

]]> By: Reinfried ../../../../2012/01/between-and-member-searching/#comment-226 Tue, 10 Apr 2012 11:07:29 +0000 http://blog.xlcubed.com/?p=3231#comment-226 Another great feature of using this option is that we can choose to leave one of the ranges empty.

Using this function following error is created:

‘Except ( AddCalculatedMembers ( {Descendants([Zeit].[Wirtschaftsjahr].[Alle Zeit],[Zeit].[Wirtschaftsjahr].[Jahr WJ],SELF)} ) , { { [Zeit].[Wirtschaftsjahr].[Jahr WJ].&[2009] : ^NULL^ } } )’

]]>