Hi Vittorio,

How are you doing today? , As per my understanding, You're absolutely right—creating a proper pivot table with dynamic month-over-month (MoM) growth in Databricks SQL Dashboards is surprisingly tricky for such a common use case. The built-in pivot table visualizations are great for summarizing, but they don’t support calculated fields or expressions on pivoted values, which makes growth calculations almost impossible without workarounds. Writing MoM growth directly in SQL can work, but like you said, it becomes rigid—you’d need to update the logic manually every time the date range changes, and it doesn't play nicely with user inputs or filters. A more flexible approach would be to pre-calculate the pivot and growth metrics in a view or Delta table, then let the dashboard visualize just the cleaned output. Or, if interactivity and dynamic comparison are essential, using a BI tool like Power BI or Tableau on top of the Databricks SQL Warehouse may give you better control over pivot logic and user-driven filters. Hopefully, calculated fields in pivot visualizations become available in Databricks soon, but until then, building the logic outside the dashboard is often the most stable path. Let me know if you’d like help designing the SQL view for this use case!

Regards,

Brahma