#CREATE TABULAR DATABASE WITH PIVOT HOW TO#
Follow the steps below to learn how to create a pivot table in datapine. They are easy to build and will help you to gain valuable insights at a quick glance. Thanks to a pivot table, you can re-arrange all that data and summarize the details of each of your items to have a clearer picture of your sales in the past half year.ĭatapine’s pivot tables are a great way to summarize, aggregate and analyze your data. In theory you could, but that would take you an indecent amount time and energy.
They will help you to quickly create a simpler cross tabulation.įor instance, as an online retailer with a thousand of products, you cannot go through the number of items you have sold over the past six months to know which item is a best-seller. These special tables are useful when you have to deal with an important amount of data to analyze, as they automatically sort, count, average or total the data that is gathered in a data source.
It will not change your spreadsheet itself but will “turn” ( pivot) the data, giving it another perspective. Pivot tables enable you to reorganize and summarize rows or columns of data so as to have another, chosen report.
0 kommentar(er)
