SharePoint Online View with group by Customer Count

%3CLINGO-SUB%20id%3D%22lingo-sub-3070059%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20View%20with%20group%20by%20Customer%20Count%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3070059%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EI%20have%20a%20list%20where%20I%20have%20all%20our%20Customers%20and%20also%20all%20the%20units%20we%20provide%20to%20the%20customers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20View%20with%20group%20by%20options%20where%20i%C2%B4m%20filtering%20out%20certain%20customers.%3C%2FP%3E%3CP%3EThe%20problem%20is%20that%20I%20dont%20want%20the%20group%20by%20to%20include%20all%20the%20units%2C%20I%20only%20want%20see%20the%20customer%20and%20have%20a%20total%20count%20on%20how%20many%20customers%20we%20have%20not%20how%20many%20units%20we%20have%20in%20total.%20Is%20this%20possible%20to%20do%3F%20I%20dont%20need%20to%20have%20the%20units%20to%20appear%20at%20all%20under%20the%20customer.%3C%2FP%3E%3CP%3ESee%20images%3A%3C%2FP%3E%3CP%3EPlease%20help!%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Customer.png%22%20style%3D%22width%3A%20815px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F341830i0C183C58F9DC14EA%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Customer.png%22%20alt%3D%22Customer.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3070059%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi!

I have a list where I have all our Customers and also all the units we provide to the customers.

 

I have created a View with group by options where i´m filtering out certain customers.

The problem is that I dont want the group by to include all the units, I only want see the customer and have a total count on how many customers we have not how many units we have in total. Is this possible to do? I dont need to have the units to appear at all under the customer.

See images:

Please help!Customer.png

0 Replies