I have a View in Lotus notes by formula.
The View is as follows by Org Exec \ Organization \ Total Headcount
I have a "show twistie when row is expandable" enabled and "Categorized" selected as Type for the column "Org Exec" & "Organization"
For example data looks like this: Marshell Rodrigues \ Tester \ 100
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.
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
any ideas or suggestion ?
What is the purpose of the view?
I am trying to Export this View in Excel Using ODBC Connection Thus i want the details at a higher level
What kind of documents are in the database?
Each employee has his record in the database with his details liek organization , execs, headcount name, serial number .
What kind of information should be displayed ?
Like i said the information to be displayed need to be at a high level for example :
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)
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.
and from which docs does the info come from?
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)
What are the column formulas?
Select form = "xyz" ....
Columns Org Execs \ Organization \ HeadCount (All 3 are fields in each record)