Forum Discussion
Pivot Table ; Ungrouping is not working
- May 23, 2022
If in query Call to change Date column data type on datetime it works.
In general, that's best practice to assign data type to each column before returning the query to grid or data model.
Please add some more details. In your image it looks like you might have two pivot tables next to each other (puts and calls). Is that the case?
What are you doing exactly when trying to ungroup?
If you're able to upload and share the file, that will help.
- yogeshkhetrapalMay 23, 2022Copper Contributor
Hi,
Exactly the point you are putting, please find attached the sheet, I need the dates in second Pivot (Call) like in first Pivot (Put) but the Ungroup feature is not working, or probably I'm using wrongly.
Thanks,
- flexyourdataMay 23, 2022Iron Contributor
Please edit the Call query and change the data type of the Date column to Date/Time:
After you close and load the changes and refresh the pivot table, you will be able to group the date field:
- yogeshkhetrapalMay 24, 2022Copper Contributor