Forum Discussion

yogeshkhetrapal's avatar
yogeshkhetrapal
Copper Contributor
May 22, 2022
Solved

Pivot Table ; Ungrouping is not working

Hi All,   Ungrouping in Date Field is not working.  Please suggest.    
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    May 23, 2022

    yogeshkhetrapal 

    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.

yogeshkhetrapal's avatar
yogeshkhetrapal
Copper Contributor
May 23, 2022

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,

flexyourdata's avatar
flexyourdata
Iron Contributor
May 23, 2022

yogeshkhetrapal 

 

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:

 

 

Resources