Forum Discussion
Pivot rows to columns with multiple values
Hi, I want to pivot the "charge_name" column shown below with 10+ catagories: I need to pivot using two value fields, qty and amount respectively: Here's how I did it: I duplicate...
There may be a better way, but your approach is probably the one I would have taken.