Comments
-
@MichelleH Thank you very much! This works like a charm. Two additional minor issues have arisen. First - is there a way to set the default variable value to the 'Max Sales Date' from the dataset? (the following suggestion does not work). Currently I would have to go in and manually change it every time there is an update.…
-
@MichelleH Removing the SUM from beast mode results in same error. Keeping the SUM but removing the MAX function and using the maximum date from the dataset works (but prevents using the date range filter). Does not work: Works but prevents date range filter: Not sure why though.
-
@MichelleH Thank you very much for your reply. Sadly that does not do the trick because if the users touch the date range filter and want to see historical results, the hard coded date from the dataset gets out of filtered range and all results end up being 0. To be more specific on what I am trying to achieve - users…