Hi team 👋 I love your product, and our stakeholders enjoy using it. Keep up the good work! I have a couple of request features for your pivot tables that I think are valuable: 1. Is it possible to have the freeze column option in pivot tables, as it is enabled in regular tables? 2. When row totals are enabled in the table, you don't sum totals of the "subtotals". 3. You group the same row values only when subtotals are enabled. I think it's cleaner to have it grouped already This one is general: Dynamic compact number format (not fixed K, M, B). For example, not 0.001B but 1M, etc., just having the format changed depending on the size of the number. Let me know if this has already been discussed, and any suggestions on how this would work. Thanks 🙏

👋 Thanks for your message - someone from the Lightdash support team will get back to you asap. Feel free to add any additional context to the thread here in the meantime (screenshots, app version if you're self-hosting etc.).

Hey Kosta, thanks for the kind words and for the detailed feedback! Here's what I found on each of these: 1. Freeze columns in pivot tables - we have an open issue for this: https://github.com/lightdash/lightdash/issues/5908. It's on our radar but not yet scheduled. I'll add a +1 for you. 2. Row totals summing subtotals - good catch, I've created an issue for this here: https://github.com/lightdash/lightdash/issues/21068 3. Grouping rows without subtotals - same here, the new issue is available here: https://github.com/lightdash/lightdash/issues/21069 4. Dynamic compact number format - I see you already created https://github.com/lightdash/lightdash/issues/20651 for this, nice one! We'll track it from there. Someone else also suggested a similar thing, and that convo was tagged in the issue, but it's an internal slack channel, so you won't be able to see it. We made some backend changes to how pivoting works in the application which were due for a long time, that should enable us to work on the features above at some point. To be transparent, none of them are on the immediate roadmap, but as that changes, you'll get updates here. Thanks again for taking the time to share these!

I've upvoted these issues for you: 🛠️ issue #5908 - this issue has been requested by 9 other users. 🛠️ issue #21068 - this issue has been requested by 1 other user. 🛠️ issue #21069 - this issue has been requested by 1 other user. 🛠️ issue #20651 - this issue has been requested by 2 other users. I'll notify everyone here as soon as any of these issues are fixed.

Thank you for the fast response, looking forward to your update!

✅ We've fixed issue #5908: _Add the option to freeze columns in a pivot table. _ Lightdash Cloud users will automatically get the fix once your instance updates (All instances update at 01:00 PST [10:00 CET] daily). Self-hosted users should update to the latest version to get the fix 🎉