title: Lotus Notes View does not hide the level of details within a column - notes domino designer
body: <p>I have a View in Lotus notes by formula.</p>
  
  <p>The View is as follows  by   Org Exec \ Organization \ Total Headcount </p>
  
  <p>I have a "show twistie when row is expandable" enabled and "Categorized" selected as Type for the column  "Org Exec" &amp; "Organization" </p>
  
  <p>For example data looks like this:  Marshell Rodrigues \ Tester \ 100</p>
  
  <p>However my problem is that tester has the list of 100 people within it and i do not want to show that level of details in the view? I want Organization not to show the list of people within it.</p>
  
  <p>I tried the Hide detail row on the Organization column properties but that does not work it still shows data within the organisation in the view</p>
  
  <p>any ideas or suggestion ? </p>
  
  <p>What is the purpose of the view? </p>
  
  <p>I am trying to Export this View in Excel Using ODBC Connection Thus i want the details at a higher level </p>
  
  <p>What kind of documents are in the database? </p>
  
  <p>Each employee has his record in the database with his details liek organization , execs, headcount name, serial number . </p>
  
  <p>What kind of information should be displayed ? </p>
  
  <p>Like i said the information to be displayed need to be at a high level for example :</p>
  
  <p>Give me All Organization Execs by Organization Total Headcount (i just want the total number i do not want to see a drill down on thoes numbers in the view)</p>
  
  <p>Example if Org "abc" has 10 headcount i just want it to display 10 ... i do not want to see who thoes 10 people are. </p>
  
  <p>and from which docs does the info come from? </p>
  
  <p>All the docs have a fields named Org Execs and Organisation and Headcount(were Headcoutn can be 1 if working and 0 if not working for individual month)</p>
  
  <p>What are the column formulas? </p>
  
  <p>Select form = "xyz" ....</p>
  
  <p>Columns Org Execs \ Organization \ HeadCount (All 3 are fields in each record)</p>