Forum Discussion
Variable in column name in summarize table
Anonymous Currently it is not supported to change the column name dynamically with the parameter.
As a workaround, I suggest using fixed "Sales" or "Total Sales" as the name of this column to indicate what this column's data describes. Then format the visual's title conditionally with the field 'Parameter'[Branch] to let users know which branch this data represents for.
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
Microsoft EmployeeOh. You can't use a variable where "BranchName" is. Why is that needed? Why not use a fixed name that reflects what is in that column like "TotalSales"? If needed, you could add another column to your table that has the branch name on every row.
Regards,
Pat
The report I want to build needs a column name on matrix table that based on user selection. That is why I need a dynamic column name