show total in a list without the entries



Hi all,

I posted a message yet, but maybe it could be wrongly understood. So
here again my problem...

I have a list with different views about our project working hours. I
want to build one more view that only displays the totals by 'Type of
Consultant' and then 'Workplace'!

Now it looks like this

Sum = 977
Type: Professional
Sum = 305
workplace: Berlin
Sum = 168
....dataentry 10
....dataentry 6
....dataentry ...
....dataentry
....dataentry
....dataentry

workplace: Cologne
Sum = ...
Type: Junior
....

it is annoying to scroll down!

It should look like this:

Sum = 977

Type: Professional Sum = 305
workplace: Berlin Sum = 168
workplace: Cologne Sum = 137

Type: Junior Sum = 672
workplace: Berlin Sum = 372
workplace: Cologne Sum = 300

That's all I want!

Thanks in advance
Daniel

.



Relevant Pages

  • Re: show total in a list without the entries
    ... My "reply" here will warn people (reading down) ... information [and probably asking questions you've answered in your ... Sum = 977 ... workplace: Cologne ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: show total in a list without the entries
    ... Why not just post this explanation to the existing thread? ... Sum = 977 ... workplace: Cologne ... it is annoying to scroll down! ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: show total in a list without the entries
    ... or do you think I should reference the threads? ... Engelbert schrieb: ... Sum = 977 ... workplace: Cologne ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: show total in a list without the entries
    ... Remove the data entry field in the view's design page. ... Sum = 977 ... workplace: Cologne ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: SMALL function seems not to work correctly
    ... Sorry Ron, I didn't scroll down far enough in that post to see that you had ... IFstatement with a very large numbers as its FALSE element: ... SUM ignores logical values in an array or reference. ...
    (microsoft.public.excel.worksheet.functions)

Loading