Sales

93

Solutions

210

Contributors

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.

Share tech news, updates, or what's on your mind.

Sign up to Post

Webroot Certification Program
We're excited to announce the launch of our Webroot Certification Program.

The Webroot Certification Program covers key feature differentiators, deployment best practices, cybersecurity management, and basic troubleshooting techniques for SecureAnywhere® Business Endpoint Protection. The program enables the sales and technical teams at managed service providers (MSPs), value-added resellers (VARs), and other distributor partners to better sell and support the solution, as well as streamline and enhance their IT services business.

Get certified by signing up here.
2
Get 15 Days FREE Full-Featured Trial
LVL 1
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Hello!

Here's the issue: I've got three columns of data: Individual, Amount Sold, Date Sold.

People have multiple sales for each given date.

I want to find each person's best night, i.e. all the sales for each given date combined for that date, and then I'd like to see the max for each individual, so I can show them their best night.

I can do this by creating a new sheet with three columns, one containing every date from 1/1/17 to 12/31/17, the next containing the name of a single person, and the third containing a SUMIF formula, so that I have the sum of each person's sales for each day, and then take the MAX from that column. I am sure, however, that there is a better way. A PivotTable seems to only give me the largest single sale from each individual, instead of the night with the largest sale.

What's the simpler solution here?
0
 
LVL 11

Expert Comment

by:Andrew Leniart
Hi Cory, welcome to Experts Exchange.

What you have done is made a post here. To get expert help, you need to "Ask a Question" so that more experts are able to see you need help. Click the Big blue button near the top of your screen.

Ask-a-Question.png

The following link explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330
1
 
LVL 20

Expert Comment

by:Roy Cox
Hi Cory, you need to look at a PivotTable with dates grouped by day
0
DNS-Protection-with-ConnectWise.png
It's always exciting around here! We're thrilled to expand our partnership with ConnectWise to offer customers better protection and performance. To get insight into why this matters, we sat down with George Anderson, Webroot’s product marketing director for business solutions, and Gavin Gamber, vice president of Channel Sales and Alliances at ConnectWise.
 
What is DNS Protection? Why is it important? Why do ConnectWise partners need this?  
 
Read more here.
4
Recognizing that digital transformations will never end can be scary, like everything in life is dynamic, it is just another challenge to be faced.

Reconhecer que as transformações digitais nunca acabarão pode ser assustador, porém como tudo na vida é dinâmico esse é mais um desafio para ser enfrentado.

http://telecoms.com/481985/digital-transformation-is-a-journey-just-dont-count-on-ever-finishing/
3
 
LVL 7

Expert Comment

by:Brian Matis
"Digital transformation itself is a thankless task. It is one which is constantly criticized and scrutinized, but there is unlikely to ever be a satisfactory answer to the question. Digital transformation is a journey, according to Whitelock. It is the constant pursuit of remaining relevant and avoiding obsolescence."

Ain't that the truth!
1
6
The role of marketing has made dramatic shifts over the last decade. With the prevalence of AI and more sophisticated business intelligence, the role of Chief Marketing Technologist has emerged to manage it all. Here's why the position matters, and how their expertise impacts the world of tech:
http://blog.experts-exchange.com/martech/chief-marketing-technologist-what-this-role-means-for-tech/
6
6
Shaun asked me who are some budding writers here at EE that he should follow.  I obliged his request and showed him some members who write articles.  Check them out.

https://www.experts-exchange.com/posts/503/Kyle-Santos-My-feed-do-not-have-enough-technical-articl.html

5
 

Administrative Comment

by:Daniella Barion
Great!
0
3
 
LVL 7

Expert Comment

by:Brian Matis
I sincerely hope (and believe) that we'll be able to get away from the current situation of people constantly looking at their phones. For AR to really live up to its full potential, we'll have to have it in some way that doesn't involve looking down at a phone screen (since, as Juana noted, you still have to interact with the world and a mobile phone makes that terrible!).

Google Glass may have failed, but I think that was more a matter of the tech not being quite ready yet. Socially, people weren't ready for it, and the design of it was far too goofy/geeky looking to take off for any sort of mainstream adoption. (Not to mention a high price point for something so new, without clear benefits.)

But take a look at how Snapchat is working on their glasses and have tried to apply some decent style to it. And when you consider that Apple has been dropping tons of hints about seriously getting into AR, I imagine we're getting very close to good wearable solutions.
0
 
LVL 7

Expert Comment

by:Brian Matis
And perhaps one day, we'll get to have a direct brain interface. Elon Musk is already on it!
1
Follow Lexie Lu if you enjoy articles about marketing, web design and graphic design.  She writes some great articles!

Click her profile and Follow.  Her articles are also listed there under 'Activity'.

https://www.experts-exchange.com/members/Lexie-Lu.html
5
 
LVL 7

Expert Comment

by:Brian Matis
Great idea, Kyle! I've seen several of her articles pop up in my feed because they're in topics I follow and have enjoyed them, so it certainly makes sense to follow her directly so I don't miss future ones :-)
1
 
LVL 1

Expert Comment

by:Juana Villa
Following :D
0

Sales

93

Solutions

210

Contributors

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.