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: trueAnd 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: trueIs there any workaround or any other way that I can use Pivot tables in a similar way?
Thanks a lot,
Ariel.
Comments
1 comment
Hi Ariel,
It appears that this is one of the things that doesn't work in the beta.
http://community.thoughtworks.com/posts/d965f18c0e
Thanks,
Jay
Please sign in to leave a comment.