# Getting Started with the KendoReact PivotGrid

This guide provides essential information about using the KendoReact PivotGrid. You will learn how to install the package, add a PivotGrid component to your project, style the component, and activate your license.

<div data-component="StartKendoReactFreeSection"></div>

After completing this guide, you will be able to reproduce the following example.

[Demo Source](https://demos.telerik.com/kendo-react-ui/pivotgrid/get-started/func/source.txt)

## Before You Begin

To follow the steps in this guide, you need to have a React project set up. If you don't have one, you can create a new React application using Vite by running the following command in your terminal:

```sh
npm create vite@latest my-app -- --template react-ts
```

This guide requires that you have **basic knowledge of React and TypeScript**, and that you have already created [**a blank React project**](https://www.telerik.com/kendo-react-ui/components/getting-started).

> tip You can speed up the development of your KendoReact application with the [Kendo UI Template Wizard for Visual Studio Code](https://marketplace.visualstudio.com/items?itemName=KendoUI.kendotemplatewizard).

## Install the Component

To install the PivotGrid package, run the following command in the root folder of your React project:

```sh
npm i @progress/kendo-react-pivotgrid
```

## Importing the Component

After installing the package, import the PivotGrid component in the React App.

In the `src/App.tsx` file of your React project, import the ` PivotGrid,` `PivotGridAxis` and `PivotGridContainer`, components from the PivotGrid package. The `PivotGridAxis` provides a single column, row, or measure Axis.

```jsx
import {
  PivotGrid,
  PivotGridContainer,
  PivotGridAxis,
} from "@progress/kendo-react-pivotgrid";
```

## Using the Component

1. Define the `defaultColumnAxes`, `defaultRowAxes` and the `defaultMeasureAxes`.

   ```jsx
   const defaultColumnAxes: PivotGridAxis[] = [
       { name: ['[Date].[Calendar]'], expand: true },
       { name: ['[Product].[Category]'] }
   ];
   const defaultRowAxes: PivotGridAxis[] = [{ name: ['[Geography].[City]'] }];
   const defaultMeasureAxes: PivotGridAxis[] = [{ name: ['[Measures].[Reseller Freight Cost]'] }];
   ```

2. Define the `catalog`, `cube`, and `url`.

   ```jsx
   const catalog = 'Adventure Works DW 2008R2';
   const cube = 'Adventure Works';
   const url = 'https://demos.telerik.com/service/v2/olap/msmdpump.dll';
   ```

3. Add the component's markup to the `src/App.tsx` file in your project and set the desired properties.

   ```jsx
   return (
       <PivotOLAPService
           catalog={catalog}
           cube={cube}
           url={url}
           defaultRowAxes={defaultRowAxes}
           defaultColumnAxes={defaultColumnAxes}
           defaultMeasureAxes={defaultMeasureAxes}
       >
           {({ pivotProps }) => (
               <PivotGridContainer>
                   <PivotGrid {...pivotProps} style={{ height: 700 }} column={WideColumn} />
               </PivotGridContainer>
           )}
       </PivotOLAPService>
   );
   ```

4. To style the PivotGrid, install and import the [Meridian theme](https://www.telerik.com/design-system/docs/themes/kendo-themes/meridian/), which is one of the [five beautiful themes](https://www.telerik.com/kendo-react-ui/components/styling) for KendoReact.

   4.1. Install the Meridian theme package.

   ```sh
   npm i @progress/kendo-theme-meridian
   ```

   4.2. Import the CSS file from the package in `src/App.tsx`. Add this import before your existing `App.css` import.

   ```jsx
   import '@progress/kendo-theme-meridian/dist/all.css';
   ```

5. Build and run the application by typing the following command in the root folder of your project:

   ```sh
   npm run dev
   ```

6. Navigate to [http://localhost:5173](http://localhost:5173/) to see the KendoReact PivotGrid component on the page.

## Activating Your License Key

**Important**: The KendoReact PivotGrid is a premium component that requires a license key file to be installed in your project:

* **Trial usage**: [Start a free trial](https://www.telerik.com/try/kendo-react-ui) and download a trial license key file
* **Commercial usage**: [Purchase a license](https://www.telerik.com/kendo-react-ui/pricing) and download a commercial license key file

Without a valid license key file, the component will display licensing warnings and watermarks.

Follow the instructions on the KendoReact [My License page](https://www.telerik.com/kendo-react-ui/components/my-license) to download and install your license key file. You can skip this step if your application already contains a KendoReact license file.

## Dependencies

The PivotGrid package requires you to install the following [peer dependencies](https://nodejs.org/en/blog/npm/peer-dependencies/) in your application:

| Package Name                     | Description                                                                                                                                                                 |
| -------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| react 18.0.0\*                   | Contains the functionality necessary to define React components.                                                                                                            |
| react-dom                        | Contains the React renderer for the web.                                                                                                                                    |
| @progress/kendo-data-query       | Contains the KendoReact data query helpers.                                                                                                                                 |
| @progress/kendo-react-intl       | Contains the KendoReact Internationalization package that applies the desired cultures by providing services and pipes for the parsing and formatting of dates and numbers. |
| @progress/kendo-react-buttons    | Contains the KendoReact Buttons components.                                                                                                                                 |
| @progress/kendo-react-treeview   | Contains the KendoReact Treeview components.                                                                                                                                |
| @progress/kendo-react-form       | Contains the KendoReact Form components.                                                                                                                                    |
| @progress/kendo-react-indicators | Contains the KendoReact Indicator components.                                                                                                                               |
| @progress/kendo-react-labels     | Contains the KendoReact Labels components.                                                                                                                                  |
| @progress/kendo-svg-icons        | Contains the KendoReact SVG icons.                                                                                                                                          |

## Suggested Links

* [API Reference of the PivotGrid](https://www.telerik.com/kendo-react-ui/components/pivotgrid/api)
* [Configurator](https://www.telerik.com/kendo-react-ui/components/pivotgrid/configurator)
* [Filtering](https://www.telerik.com/kendo-react-ui/components/pivotgrid/filtering)
* [Sorting](https://www.telerik.com/kendo-react-ui/components/pivotgrid/sorting)
* [FAQ](https://www.telerik.com/kendo-react-ui/components/pivotgrid/faq)

## Learning Resources

* [Getting Started with KendoReact](https://www.telerik.com/kendo-react-ui/components/getting-started)
* [Virtual Classroom (Training Courses for Registered Users)](https://learn.telerik.com/learn/course/external/view/elearning/14/kendoreact)
* [Explore the Finance Portfolio Sample Application](https://www.telerik.com/kendo-react-ui/components/sample-applications/finance-application/)
* [Explore the Coffee Warehouse Sample Application](https://www.telerik.com/kendo-react-ui/components/sample-applications/react-coffee-warehouse-dashboard/)
* [Explore the GitHub Issues Grid Sample Application](https://www.telerik.com/kendo-react-ui/components/sample-applications/issues-grid/)
