I am trying to create a median measure on a particular column in my excel pivot table. I have done so successfully for one column but am unable to do so for another column. I get the following message:
"The measure formula is invalid and contains errors".
When I set up the pivot I made sure to tick "add this data to the data model ". Then I right click in the pivot fields to add the measure. The measure is just a simple =median([columnname]). As I say it worked for one column but not another.
I have checked that the column format is numbers. I have deleted the first measure to see if I can create the new measure only but it doesnt like that either. Initially I had no data in the columns as it hasnt been added yet, but I have added dummy data for now to see if that helps. No! Has anyone got any bright ideas.
"The measure formula is invalid and contains errors".
When I set up the pivot I made sure to tick "add this data to the data model ". Then I right click in the pivot fields to add the measure. The measure is just a simple =median([columnname]). As I say it worked for one column but not another.
I have checked that the column format is numbers. I have deleted the first measure to see if I can create the new measure only but it doesnt like that either. Initially I had no data in the columns as it hasnt been added yet, but I have added dummy data for now to see if that helps. No! Has anyone got any bright ideas.