If you want to apply a minor tweak to the document, it must not take long to Collate chart article. This type of basic action does not have to require extra education or running through manuals to understand it. With the right document editing resource, you will not spend more time than is needed for such a quick change. Use DocHub to simplify your editing process whether you are an experienced user or if it’s the first time making use of a web-based editor service. This tool will require minutes or so to learn to Collate chart article. The sole thing required to get more effective with editing is a DocHub profile.
A plain document editor like DocHub will help you optimize the time you need to spend on document editing no matter your previous knowledge of this kind of tools. Create an account now and enhance your efficiency instantly with DocHub!
Did you ever need to make a pivot table that needed information from multiple tables? So for example, you needed to look up the customer code from the master data table so you could bring in the customer description in your pivot table report? The old way to do this was to use a lookup function, like VLOOKUP and add new columns to your source data and bring in the information you need from the lookup tables. The better way of doing this is to leave your tables as is and instead use relationships. Lets create a pivot table based on multiple tables. (upbeat music) In this lecture, lets take a look at a practical example of using the data model. What we want to do is to create two types of report. Report number one is about customers and their sales values sorted in descending order. Report number two is quantity sold by article. Our data is sitting in different tables. Our main table, so our fact table, is this table right here which is called TableSales. Now all the information here