New pivot - headers are limited to one row

[andre-berlin]

I'm building a report with the new pivot table and I wan't to have the header titles to automatically change height depending on the amount of text, like they do in the new straight table. I don't think there is a setting for this but perhaps it is something that can be fixed with some custom css? The table becomes super wide if all text is going to be displayed and that means a lot of scrolling... I've played around with css but can't get it to work - any help would be appreciated!

[mattie236]

---

@andre-berlin hhaexchangewrote:

I'm building a report with the new pivot table and I wan't to have the header titles to automatically change height depending on the amount of text, like they do in the new straight table. I don't think there is a setting for this but perhaps it is something that can be fixed with some custom css? The table becomes super wide if all text is going to be displayed and that means a lot of scrolling... I've played around with css but can't get it to work - any help would be appreciated!

---

While it's not possible to have a single view that allows for both selective editing and a column sum, you can achieve this by using **Airtable Interfaces**. Interfaces are a separate tool within Airtable designed to create user-friendly dashboards on top of your data. You can build an interface that contains a list of records with only certain fields marked as editable, and you can add a separate **`Number` element** on the same page that aggregates and displays the sum of your budget column. This method gives you complete control over which fields can be changed while still providing the automatically calculated sum you need.

[robert_mika]

Does this relate to the question?

[andre-berlin]

@mattie236 I don't think your answer relates to my question. This is about the New Pivot table viz in Qlik Sense - Airtable interfaces has little to do with that?

[BPiotrowski · Accepted solution]

Hi

Here's some CSS 😀

My Object ID: Gmev

#Gmev_content div[data-cell-type="P"] span, #Gmev_content div[data-testid="title-cell"] span{
display: block!important;
word-break: normal !important;
white-space: pre-line!important;
}

If u want all pivots to be multirow just delete #Gmev_content and in case it did not worked for u there are try adding these:
overflow-wrap: anywhere !important;
overflow: unset !important;

and if u are using already some custom styles u need to be careful u might have set some class that influence more than u expect 

[andre-berlin]

@BPiotrowski - amazing works exactly like I wanted it to 🙂 And I usually refrain from using custom css styling but this just felt worth it. Thanks a lot for your help!