"Pivot table - ""Nested IN"" error"

Hi all, I know this is a beta feature but I´m getting the following error and I would like to double check if I´m doing something wrong or this is not yet supported.

I´m executing the following MQL:


  pivot-table:
    conditions:  type = "Designation" AND 'Team Member' IN (SELECT number Where type = 'Team Member' AND Location = BA)
    aggregation: sum('Planned FTE')
    rows: 'project name'
    columns: 'Month'
    empty-rows: false
    empty-columns: false
    totals: true

And I´m getting the following error:

undefined method `accept' for nil:NilClass Help

If this doesn´t work I have to hardcode all existing team members from that location in all the MQLs which I don´t like because the Team Members assigned to a specif project are constantly changing

This is what I have to do:


  pivot-table:
    conditions:  type = "Designation" AND 'Team Member' numbers in (5, 8, 9, 10, 11, 12, 13, 30, 31, 32, 33, 74)
    aggregation: sum('Planned FTE')
    rows: 'project name'
    columns: 'Month'
    empty-rows: false
    empty-columns: false
    totals: true

Is there any workaround or any other way that I can use Pivot tables in a similar way?

Thanks a lot,

Ariel.