Afternoon,
I have a table feeding a pivot table with data, but I have noticed that the table figures and pivot table figures are different.
ie the table shows 29,645 call, but when the pivot table runs it shows the value as 16,834
The Value is showing as "sum" in the pivot table values, is there anyway I can just pull the figure as is through as I have slicers on the pivot table?
thanks in advance
Gavin
I have a table feeding a pivot table with data, but I have noticed that the table figures and pivot table figures are different.
ie the table shows 29,645 call, but when the pivot table runs it shows the value as 16,834
The Value is showing as "sum" in the pivot table values, is there anyway I can just pull the figure as is through as I have slicers on the pivot table?
thanks in advance
Gavin