I have created a query that summarizes data across several dimensions. I then created a pivot table based on this query. When I look at the raw data in the query - numbers such as 10.5, 8.83, etc. show up. However, when they are sucked into the pivot table, it seems that the pivot table has truncated the data (not rounded).
The data in the query is formatted a s standard with 2 decimal places.
Anyone have any insight into this?
The data in the query is formatted a s standard with 2 decimal places.
Anyone have any insight into this?
