Forum Discussion
Trim Range Operator not working in Range Reference for Pivot Table
I am getting an error message when I try to use Trim Range Operator does not work. Not sure why? Not sure if there is any resolution or bypass to this?
In this case you may consider to use PIVOTBY() function with TRIMRANGE operator.