Hi ,
I have a report which shows 4 columns : Work Area, Level,Category & Count(Level).
For Every Work Area we have 3 levels : A,B & C and for each level we can have multiple category.
In the summary line I want to show the sum of the count of the individual levels. The list view is shown below.
------------------------------------------------------------------------------------
[Work Area] [Level] [Category] <count [Level]>
------------------------------------------------------------------------------------
WA 1 A C1 1
WA 1 A C2 4
WA 1 B C1 3
WA 1 C C1 0
------------------------------------------------------------------------------------
WA 1 [level A]:5 [level B]:3 [level C]:0 8
------------------------------------------------------------------------------------
WA 2 A c1 0
WA 2 B C1 2
WA 2 B C3 2
WA 2 C C1 5
WA 2 C C2 1
------------------------------------------------------------------------------------
WA 2 [level A]:0 [level B]:4 [level C]:6 10
------------------------------------------------------------------------------------
WA 2 A C1 1
WA 2 B C1 1
WA 2 C C1 1
------------------------------------------------------------------------------------
WA 2 [level A]:1 [level B]:1 [level C]:1 3
------------------------------------------------------------------------------------
Need help to resolve this issue.
Thanks
Dsg.
Hi dsg1,
as I understand your post:
You have already created a report with the 4 columns, but you don't know, how to do the summary line ?
I guess, the report you have is a list report. To add summary lines, you first have to go to list properties
Grouping & Sorting and tell the report to be grouped by [Work Area] and [Level].
After that you can add summary lines by marking measure column [count[Level]] and clicking on the Summary Symbol on the Pane.
Now summary lines are added for each grouping + overall.