Yes, your assumption is correct. Unlike RadGrid, RadPivotGrid needs you to define the fields collection initially since the columns, rows and aggregate fields structure can vary greatly depending on your requirements. I suggest that you download and run the web site provided in the following blog for a basic sample:
Hope this helps.
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.