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.
Group or ungroup data in a PivotTable
Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list of dates or times (date and time fields in the PivotTable) into quarters and months, like this image...see the upper link.
Hope I was able to help you with this information.
I know I don't know anything (Socrates)
Hi,
Thank you so much!!!
But the concern is the ungroup feature is not working or probably I'm using wrongly, attaching the sheet for your reference.
- SergeiBaklanMay 23, 2022Diamond Contributor
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.
- yogeshkhetrapalMay 24, 2022Copper Contributor
- SergeiBaklanMay 24, 2022Diamond Contributor
yogeshkhetrapal , you are welcome