I created a pivot table from multiple ranges on multiple sheets (consolidated pivot table). I want the information on the pivot table to refelct the info from my tables, like to show values. However, the data that is pulled is reflecting a 'count' of pulled data.
How do I get around this...