Databricks Community

I'm trying to implement a percent of total measure in pivot table. I succeeded in creating a measure using the below formula.However, I want this measure to recognize global filter selections. For example, I want to show emissions share by category. ...

Is there a way to show values in columns instead of rows in pivot table function?I have fields I want to show as rows, and when I want to add multiple fields under values, they show as rows instead of columns.I want each values field to show as colum...