Adding two field into Pivot Table

I

IF Statement

Hello,

I have this pivot table setup and added few additional column worth of data.
What I am trying to do to get data from new additional column.

This is what I have in Data field.
2007-02-28 2008-02-28 Variances
$80.00 $100.00 -$20.00

This is what I am looking to pull from new data.
2007-02-28 2008-02-28 Variances GL RC
$80.00 $100.00 -$20.00 010 111

When I added GL & RC field to data field, it give me the result on count
base (1 or 2) rather than 010 & 111. How can I get the correct data rather
than count of GL & RC?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table (Grand Total) 1
Create Variances using Pivot Table 4
Creating Pivot Table with Macro using Multiple Sheets 0
Pivot Table Counting Text Data 0
Additional columns for Pivot table 0
Pivot Tables 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
Sorting in Pivot table 0

Top