SOLVED

Pivot Table ; Ungrouping is not working

Occasional Contributor

Hi All,

 

Ungrouping in Date Field is not working.  Please suggest.

 

yogeshkhetrapal_0-1653218734779.png

 

9 Replies

@yogeshkhetrapal 

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.

 

NikolinoDE

I know I don't know anything (Socrates)

@yogeshkhetrapal 

 

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.

@flexyourdata 

 

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,

@NikolinoDE 

 

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.

best response confirmed by yogeshkhetrapal (Occasional Contributor)
Solution

@yogeshkhetrapal 

If in query Call to change Date column data type on datetime it works.

image.png

 

In general, that's best practice to assign data type to each column before returning the query to grid or data model.

@yogeshkhetrapal 

 

Please edit the Call query and change the data type of the Date column to Date/Time:

 

flexyourdata_0-1653311425078.png

 

After you close and load the changes and refresh the pivot table, you will be able to group the date field:

flexyourdata_1-1653311464755.png

 

 

@Sergei Baklan 

 

Hi,

Really thankful to you for your response as well feed back.

@flexyourdata 

 

Thank you so much it started working.

@yogeshkhetrapal , you are welcome