Forum Discussion

CEllis's avatar
CEllis
Icon for Resolver I rankResolver I
3 years ago
Solved

Pivot Table

I have come across this error and seen it discussed here and would like to see if this makes sence ?       Expression.Error: There weren't enough elements in the enumeration to complete the operati...
General Comment
Need Help
  • HotChilli's avatar
    HotChilli
    3 years ago

    If you choose "Don't Aggregate" there are two values for the 'English' assessment.  2 into 1 does not go.

    So you either use an aggregate or introduce another column e.g. an Index, to prevent aggregation

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
3 years ago

If you choose "Don't Aggregate" there are two values for the 'English' assessment.  2 into 1 does not go.

So you either use an aggregate or introduce another column e.g. an Index, to prevent aggregation

  • CEllis's avatar
    CEllis
    Icon for Resolver I rankResolver I
    3 years ago

    Thanks for the response.

     

    Ah think I have got it, the pivot acts like a group query were it needs to group on the other columns and aggrigates the value to stop it appearing on seprate rows.

     

    I've added a key into the list and used Max, when I refresh the error has stopped.

     

    Many thanks HotChilli