4 Replies Latest reply on Mar 4, 2017 9:50 PM by Kurt Heisler

# Show sum of records in header (level of detail?)

I have data with three columns: Region (East or West), SalesPerson (a name), and Quota (Close, Over, Under). Workbook is attached.

I would like to show the total number of sales people in each region, and show that number under the header (like in the picture). I would like this number fixed no matter the view or filters in place (i.e., Level of Detail). I can't t figure out how to write the LOD expression so it's limited to a particular region, like one LOD for East and another for West. For example, this LOD will return the total for both regions:

{ FIXED [Region]:sum([Number of Records])}

Can this be tweaked so it's only for a specific Region?

And if I get the LODs right, I'm then unsure how to incorporate it into the view as in the picture. Thanks for any help!

• ###### 1. Re: Show sum of records in header (level of detail?)

Hi Kurt,

Find my approach based on LOD-expression below and stored in attached workbook version located in the original thread

1. count Sales Person: {fixed [Region]:count([Sales Person])}

2. Drag the calculated field to the Columns shelf between Region & Quota and ensure it's Discrete

Regards,

Norbert

2 of 2 people found this helpful
• ###### 2. Re: Show sum of records in header (level of detail?)

Hi Kurt,

Pl find attached in 10.2 and see screenshots. I used a parameter to get this.

For East

FOR West

I used parameter and created a Region filter and dragged it to Filter, set it to true, I also dragged that filter into the FIXED LOD.

Region Filter

FIXED LOD

Hope it Heps!!!

Thanks

Deepak

• ###### 3. Re: Show sum of records in header (level of detail?)

I did a slightly different spin on your graph, purely because I think if things are a percentage they shouldn't be displayed side by side

• ###### 4. Re: Show sum of records in header (level of detail?)

Thanks everyone for your suggestions. Norbert - I went with your approach as it got closest to what I was going for. To get the "(   )" around the number, I created this calculated field:

"("+STR([count Sales Person])+")"

... and added it to the view instead of the actual LOD field.