2 Replies Latest reply: Jan 30, 2018 5:22 AM by Anindya Manna RSS

    How to add Bookmark filter with other filter in set expression?

    Anindya Manna

      Hi all,

      I am writing a set expression with bookmark filter and other filters. But it is not working fine.When I am apllying BM(Id-qjyVTq) separately it is working fine like below.

      sum({qjyVTq}[Sales Amt])

      And when applying other filter it is also working fine

      sum({$<[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])

       

      Now I want to combine this two like below

      sum({$<{qjyVTq},[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])

      But this not working.

      Experts Please help me on this.