# Pict Table - Years as column & row

**URL:** https://community.noloco.io/t/pict-table-years-as-column-row/2457
**Category:** Feature Requests
**Tags:** feature-request
**Created:** [June 3, 2026, 9:38am UTC](https://community.noloco.io/t/pict-table-years-as-column-row/2457 "2026-06-03T09:38:48Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)
#### Post date: [June 3, 2026, 9:38am UTC](https://community.noloco.io/t/pict-table-years-as-column-row/2457/1 "2026-06-03T09:38:49Z")

</div>

Hi all, has anyne found a way to configure a pivot table so the date field can be both columns and rows?

I have a lot of tables currently running on mysql queries but I’m trying to migrate these to Noloco pivot tables.

The mysql query display as below, you can see its the same datefield, just grouped by year in rows, and month in columns.

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/2X/9/9b5a5a959a021a6e4d5fa43bb1d3fad969845adc.png)

And this is how it looks using a noloco pivot:

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/2X/9/9cd498de338d2c672655cfc963cb7aa047a6d962.png)

---

<div class="post-metadata">

### Author: ![darragh](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/darragh/32/12_2.png) [@darragh](https://community.noloco.io/u/darragh)
#### Post date: [June 3, 2026, 11:01am UTC](https://community.noloco.io/t/pict-table-years-as-column-row/2457/2 "2026-06-03T11:01:14Z")

</div>

I would reccomend breaking your date field into 2 new formula fields:

One which is `year` and another which is `month`  
For month I would probably use the numeric month like `01 - Jan`, `02 - Feb` (for example)

The formula would just be `TEXT({dateField}, "YYYY")` and `TEXT({dateField}, "MM - MMM")`

---

<div class="post-metadata">

### Author: ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)
#### Post date: [June 3, 2026, 11:54am UTC](https://community.noloco.io/t/pict-table-years-as-column-row/2457/3 "2026-06-03T11:54:47Z")

</div>

Thanks @darragh , unfortunately my reports run across many (10+) date fields depending on what the end result should be, so not keen on creating 20 extra fields in the tables. Ill keep using the queries for now 👋

---

<div class="post-metadata">

### Author: ![darragh](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/darragh/32/12_2.png) [@darragh](https://community.noloco.io/u/darragh)
#### Post date: [June 3, 2026, 7:52pm UTC](https://community.noloco.io/t/pict-table-years-as-column-row/2457/4 "2026-06-03T19:52:23Z")

</div>

I see, well without transforming your data into that format, I don’t think there’s another option actually.