Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Rows vs. Values - Different Results

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.

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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?

2 Replies

  • serpiva64's avatar
    serpiva64
    Solution Sage
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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?