Forum Discussion

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 24, 2019

othafa 

You need to refresh.

First refresh the PQ table -> right click -> refresh.

Then refresh the pivot table -> right click -> refresh.

 

othafa's avatar
othafa
Copper Contributor
Apr 24, 2019
Ok that's fine, just one last issue I think!

I'm just getting a count of name in the pivot table, cant see how to actually convert that to the name of the staff?
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Apr 24, 2019

    othafa 

    I provided a link to an article from Mr Excel in the workbook. Just follow the steps.

     

    • othafa's avatar
      othafa
      Copper Contributor
      Apr 25, 2019

      Detlef_Lewin 

      Hi, many apologies but I've hit a snag. When I was working on your fix for the problem I was using my home version of excel which is Microsoft Office 2016. Unfortunately the version at work is Office Standard  2010 and reading up on it online the Power Query is not available for this version, only the professional plus 2010.

       

      What this means is that I don't get the option of adding the data to the data model when I create the pivot table.

       

      Back to square one?

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Apr 25, 2019

         

        othafa wrote:

        Back to square one?

        So it seems.

        Or you could argue with your boss and your IT that with a more recent version of Excel you will be able to perform this specific task easily.

        And besides Excel 2010 is almost 10 years old.

    • othafa's avatar
      othafa
      Copper Contributor
      Apr 24, 2019
      Ok got it now thanks so much for all your help.
      Vest wishes

Resources