---
title: "Error: Dragging Date Dimension Level Into Pivot Table"
description: "## Symptoms   In a pivot table while dragging a dimension level that is associated with a date, the user may encounter an error. No message will be shown, but the user will be unable to select/drag the dimension level.…"
url: "https://globaldata365.com/helpcenter/error-dragging-date-dimension-level-into-pivot-table/"
updated: "2026-10-25"
category: Jet Analytics
tags:
  - jet analytics
---

# Error: Dragging Date Dimension Level Into Pivot Table

## Symptoms

 

In a pivot table while dragging a dimension level that is associated with a date, the user may encounter an error. No message will be shown, but the user will be unable to select/drag the dimension level.

 

## Resolution

 

To resolve this error, you will need to convert the field from a datetime to a text data type.

 

**1.** Inside Staging database, we will use the *Last Date Modified* from our *Item* table.

![](https://globaldata365.com/wp-content/uploads/2023/06/image-35.png)

> If you hover over the field with your cursor, it will display the data type of the field.

**2.** Right click the field and select **Field Transformations**.

![](https://globaldata365.com/wp-content/uploads/2023/06/image-36.png)

**3.** From the **Field Transformation** dialog select an operator type of **Custom**. Click **Add**.

![Error: Dragging Date Dimension Level Into Pivot Table](https://globaldata365.com/wp-content/uploads/2023/06/image-37.png)

**4.** In the **Transformation Custom SQL**window, type the convert statement that uses the date field which you are trying to convert as the expression.

 **Want to turn raw ERP data into powerful business insights?**
[👉 Join our Jet Analytics Training](https://globaldata365.com/jet-analytics-training/) and master building data warehouses, cubes, and advanced dashboards.

In this example, we are trying to convert the *Last Date Modified* field.  To do this, we start typing our convert statement, enter a data type of varchar(20), drag the field from the right pane to the left pane, and apply a style as the final parameter.  Once finished, click **OK**.

![Error: Dragging Date Dimension Level Into Pivot Table](https://globaldata365.com/wp-content/uploads/2023/06/image-38-1024x647.png)

> For more information on the CONVERT statement see the following link: [CONVERT ](http://msdn.microsoft.com/en-us/library/ms187928.aspx)Statement

**5)** Drag and drop the *Last Date Modified* field into your data warehouse.

Right click the field and select **Edit Field**. The **Edit Custom Field dialog **opens. In this dialog, make sure the data type matches the one you stated in your convert statement above. Click **OK.**

![Error: Dragging Date Dimension Level Into Pivot Table](https://globaldata365.com/wp-content/uploads/2023/06/image-39.png)

**6)**From the ribbon, click **Deploy and Execute Modified Tables and Views **to apply the changes above.

![Error: Dragging Date Dimension Level Into Pivot Table](https://globaldata365.com/wp-content/uploads/2023/06/image-40.png)

**7)**Deploy and execute any dependent objects in our OLAP database.

Once the deployment and execution is completed, you should now be able to drag the date dimension level into your pivot table.

 

#### If You Need Any Help, [Contact us](https://globaldata365.com/contact/) Now!

###### Still have Questions?

Ask us anything about this article – we’ll get backto you shortly. 

.elementor-template-wrapper.elementor-template-53310 { display: block; width: 100%; clear: both; position: relative; z-index: 1; margin: 30px 0 40px; padding: 0; box-sizing: border-box; }

/* Make sure Elementor's generated content participates normally in the document flow */ .elementor-template-wrapper.elementor-template-53310 .elementor { position: relative; width: 100%; }

/* Prevent floated elements above/below from causing the template to overlap */ .elementor-template-wrapper.elementor-template-53310::after { content: ""; display: table; clear: both; }

/* Mobile spacing */ @media (max-width: 767px) { .elementor-template-wrapper.elementor-template-53310 { margin: 25px 0 30px; } }