[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Raw Accounting Data in Excel- Need to build Reports

Posted on 2013-06-23
2
Medium Priority
?
368 Views
Last Modified: 2013-06-27
Hello Tech Team,

I have exported sales info from our accounting software to an excel spreadsheet.  I want to make sense of this raw information for our sales staff and management.  Currently, the sales manager takes 2-3 days building a report that we want to generate with a click of a button.  Is it possible to use Crystal Reports or is there an excel spreadsheet out there that is already setup?  

My aim is to be able to generate volume information by Month and within a given month by Customer ID, Customer Type, Product, Location.  Also, to have comparisons of YTD etc


Any suggestions would be grateful.
0
Comment
Question by:cddl
2 Comments
 
LVL 70

Accepted Solution

by:
KCTS earned 1500 total points
ID: 39270047
A pivot table will do most, if not all of what you want - see http://spreadsheets.about.com/b/2012/06/01/excel-2007-pivot-table-tutorial-2.htm
0
 

Author Closing Comment

by:cddl
ID: 39282563
The pivot table is a good option.  Is there a way to use Crystal reports with the excel spreadsheet being the database?
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question