I can’t seen to move Gross Sale into the values section of the pivot table using Analyze in Excel.
Here are the steps I took in Analyze in Excel
I published the .pbix to the service, select Analyze in Excel, then downloaded file to my machine. When trying to move Gross Sales into the value section of the pivot table I received the following error message.
In your example you are only using implicit measures, is that also the case in your production file? If so, create explicit measures for all these numerical fields and hide those columns in the model.
Hi @ambidextrousmentally, did the response provided by @Melissa help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.