> ## Documentation Index
> Fetch the complete documentation index at: https://doc.lucidworks.com/llms.txt
> Use this file to discover all available pages before exploring further.

# pivot:table

export const LwTemplate = ({title = "Key questions to get you started", icon = "sparkles", cta = "Powered by Agent Studio", linkHref = "https://lucidworks.com/demo/?utm_source=docs&utm_medium=referral&utm_campaign=docs_cta_ai"}) => {
  const [isLoaded, setIsLoaded] = useState(false);
  useEffect(() => {
    const timer = setTimeout(() => {
      setIsLoaded(true);
    }, 500);
    return () => clearTimeout(timer);
  }, []);
  return <div className="lw-template-container">
      <Card title={title} icon={icon}>
        {isLoaded && <span dangerouslySetInnerHTML={{
    __html: `<lw-template id="a029c1a9-28be-427e-b0e1-5d918920246a"></lw-template
            >`
  }} />}
        <Link href={linkHref} className="agent-studio-link text-left text-gray-600 gap-2 dark:text-gray-400 text-sm font-medium flex flex-row items-center hover:text-primary dark:hover:text-primary-light group-hover:text-primary group-hover:dark:text-primary-light">Powered by Lucidworks Agent Studio</Link>
      </Card>
    </div>;
};

[localhost link]: http://localhost:3000/docs/4/app-studio/reference/tags/lightning.directive.pivotTable

[mintlify link]: https://doc.lucidworks.com/docs/4/app-studio/reference/tags/lightning.directive.pivotTable

[old doc.lw link]: https://doc.lucidworks.com/app-studio/4.2/1155

<LwTemplate />

## Description

Display a facet with related filters as a table

## Usage

as element:

```xml wrap  theme={"dark"}
<pivot:table
       platform="{string}"
       query="{string}"
       facet="{string}"
       expand-query="{string}"
       expand-facet="{string}"
       [expand="{boolean}"]
       [field="{string}"]>
</pivot:table>
```

#### Parameters

| Param                | Type        | Details                                   |
| -------------------- | ----------- | ----------------------------------------- |
| platform             | **string**  | The platform to query against             |
| query                | **string**  | The query to use                          |
| facet                | **string**  | The facet to display                      |
| expand-query         | **string**  | The query to use for expanding            |
| expand-facet         | **string**  | The facet to pivot on when expanding      |
| expand  *(optional)* | **boolean** | Allow expanding. Default: true            |
| field  *(optional)*  | **string**  | The filter field name to add to the query |