Pivot Tables
 

Ok...i'm stuck on this pivot table issue. Based on my data, i've got 3
data columns, one is called Base, Uplift and Demand. These are all
numeric. I've also got one that is called Changes, which consist of
reviewed or unreviewed. How do I show this figure when i have it in a
pivot table as it is only showing the sum/count of it. I need it to
show reviewed or unreviewed. Can someone help me with this?thanks

Pivot Tables
 

In the source data, add a column to calculate a number for Change
Status. For example, if the Change is in column C:
=IF(C2="Reviewed",1,0)

Then, add the ChangeStatus field to the pivot table, instead of using
the original Change field.

Format the Change field in the pivot table with custom number format:
Right-click on the Change field heading, and choose Field Settings
Click the Numbers button
From the Category list, choose Custom
In the text box, enter:
[0]"Reviewed";[=0]"Unreviewed"
Click OK, click OK


Gor_yee wrote:
Ok...i'm stuck on this pivot table issue. Based on my data, i've got 3
data columns, one is called Base, Uplift and Demand. These are all
numeric. I've also got one that is called Changes, which consist of
reviewed or unreviewed. How do I show this figure when i have it in a
pivot table as it is only showing the sum/count of it. I need it to
show reviewed or unreviewed. Can someone help me with this?thanks


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html