Your question is very vague.
If you mean the number format of a measure, click on the small black arrow => last option => Number format
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi Expert how to change datatype in pivot table in excel sheets . from text to numbers
currently value is in text as it is in column section
i,e.
id value
1 23
Your question is very vague.
If you mean the number format of a measure, click on the small black arrow => last option => Number format
error pivot table cannot be updates with differ layout
suggestion please
Hi @Shambhu Rai
I creates a sample, and as you said put number values in Column Field.
I suggest you select these cells, right click them > Field Settings > Number format > Choose "Number" format.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi Expert,
i am using ssas cube and option is disables