I think probably your real data file has numbers stored as text. Changing the data source of the pivot table in your example to use Sheet2 data results in values for the SUM fields.
I think probably your real data file has numbers stored as text. Changing the data source of the pivot table in your example to use Sheet2 data results in values for the SUM fields.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks