ST Alpha - "Like, let's say you have a raw data table of all your company sales/invoices over the past 5 years ... you could use a pivot table to divide it by" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 185

In response to "It allows you to analyze a huge data table by aggregating various columns and performing calculations with the intersecting data -- nm" by Beryllium

Like, let's say you have a raw data table of all your company sales/invoices over the past 5 years ... you could use a pivot table to divide it by

Posted by Beryllium (aka grayman) Sep 13 '11, 09:06

month, and then graph the result to see your monthly performance over the past five years.

But that's just a basic example, there are way more complex things you can do with it.

Responses:

Hmmm. I used to work with data sets too big for Excel. Not sure if that would have helped in this case, because you could not import the data. - muzungu psilotum Sep 13, 09:09 2
- excel used to have a 65,000 row limit, that doesn't apply any more -- nm - Beryllium Sep 13, 09:10 1
  - This was exactly my problem. - muzungu psilotum Sep 13, 09:11

Post a message top

Like, let's say you have a raw data table of all your company sales/invoices over the past 5 years ... you could use a pivot table to divide it by

Replies are disabled on threads older than 7 days.