With pivot tables, you could perform such actions right on the table itself. If you wanted to generate crosstab reports for this data, you would need to go back to the drawing board in your crosstab software to generate new reports with new variables to showcase the new data you wanted to view. But now let’s say you wanted to more deeply analyze the data, looking at a breakdown of sales based on the region and products sold. In this case, you decided to look at a month-by-month breakdown of sales by your three associates. Crosstabs let you quickly compare, contrast and otherwise assess sales activity based on the variables you chose. Crosstab software could help you set up a table that looked something like this: Pivot tables generally offer a batch of added benefits and features that may not be available with crosstabs.Ĭrosstab Explained Let’s say you wanted to review sales made by your associates over the first three months of the year. Despite their obvious similarities, however, the two also have some very obvious differences. Both feature rows and columns of data in a tabular format, providing select details and totals as desired. Crosstabs and pivot tables are both useful ways to analyze data, and they may even appear identical at a glance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |