Rows vs. Values - Different Results

[Anonymous]

I've created a table that has a list of projects with Project Names and Project #'s.   When the Project # is listed in the "Rows" field, the project # for both projects appears.    

However, when I move Project # to the "Values" field, it drops one of the Project #'s.

[serpiva64]

Hi,

seeing the +/- icon on the left of your column project name it seems you have something else on the rows.

Can you expand it?

[Anonymous · Accepted solution]

When I expanded the plus sign, and drill to the furthest point, there is no project #.    Which explains why the aggregation to the parent level is blank.    But yet, changing the table to show the Project # as a Row, it does appear?    Any suggestions?