Nested IN' being used in Pivot Tables?

Follow

Comments

1 comment

  • Avatar
    Jay Mitchell

    Hi Sam,


    Thanks for the helpful example. You're right that the structure of the original table suggests that you should be able to create a pivot table from that data. Unfortunately, it does appear that pivot tables don't work with nested IN. I have added this to our backlog. Sorry about the 18 value queries.


    Thanks,


    Jay

Please sign in to leave a comment.