I am having a issue with making my pivot table dynamic.
I have set the source up as a "Table" and linked my PivotTable. When I refresh my data the data will be shown in the field list. However, I want it to automatically insert in the "Values" field as "Sum of", how do I do that?
The new data are the upcoming quaters. I believe I have to arrange my pivot this way so "omr?de (Area)" is in the columns and the values of the quarter is in the rows.
Thank you in advance.
Bookmarks