Pivot table

[Martin Coates]

Hi. I'm trying to report on 100 customers. A select 20 I want to list individually every month, these are not necessarily the top 20 but a select 20 and the other 80 I just want a combined total and not to be listed individually. I can get the select 20 without any trouble but I can't find a way to group the remaining 80 as one so to speak. Any ideas anyone?

 

[James006]

Hi,

Is there a dedicated field in your database which allows to differentiate the ' selected ' vs the ' non-selected ' ...

Debra has an excellent explanation about how to group ...

https://www.contextures.com/xlPivot07.html

Hope this will help

 

[Martin Coates]

1

 

[James006]

1

???

Not sure to understand your message ...

 

[Martin Coates]

Sorry, mis-post!!!
I was trying to insert a screen shot of my spreadsheet but it won't let me????
I have followed the advise you have sent me but I still can't get just a total for the unselected group, it still lists each customer within the group individually. I'm looking at field settings at the moment but this isn't helping. It seems to be all or nothing to me.

 

[Martin Coates]

I think I've solved it, thanks for your help

 

[James006]

I think I've solved it, thanks for your help

You are welcome ...:wink: