Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Field Select in a Pivot Table
Here is my situation:
I have a pivot table set up and I understand how I can show or hide detail. I have a field for a 'SystemID' and another is for the "UserName". To maintain anomynity of the user's name in a chart, we only want the 'SystemID' to be visible with the data. Yet, we want to use the 'UserName' when we are selecting who's data we want to refresh on the chart. I have the HideDetail enabled for the 'UserName' as well as 'Show Items with no Data', but it does not work. It will only display the ones with data that pertain to the 'UserName'. Yet, when I have these enabled for the 'SystemID' I receive ones without data that I did not select from the 'UserName' field. What am I doing wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting of Pivot Table Field | Excel Discussion (Misc queries) | |||
Pivot Table Page Field Area Broken | Excel Discussion (Misc queries) | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Field Source Error for Pivot Table | Excel Worksheet Functions | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |