Calculated item in Pivot table error when field is grouped

Question

Answer 1

Hi @fahim ruwala

According to your image, although you did not select the Dates field for the pivot table, in the fields list, Dates is automatically grouped into the Years field, you need to ungroup this first.

• Please select the Dates and Years fields on Rows area like following image.
  
• Then please select one cell of Dates on pivot table, right-click it, click “Ungroup", the group fields would be removed from fields list, such as the Years field.
  
  
• Now you can remove the Dates field, and insert the Calculated item.
  

---

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.

---