I need to us the pivot too, so the GM_Naam field are rows and the BG2015 fields are separate columns containing the Area_Ha values.

But when I look at the resulting table, the GM_Naam field is completely blank.

Any way to fix this, so the GM_naams show?

I input GM_Naam, Pivot BG2015, Value Area_Ha

this is what the pivot table looks like after I've set the input, pivot, and value field

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.