Just me, or does anyone else always have performance issues with Analytic Workbook? SuiteAnswers suggested I create a Workbook to calculate Monthly Transaction Line Usage but it can't handle any more than a couple hundred thousand transaction lines. We average over 2 million transaction lines per month.. I've tried to create other workbooks with different data types (nothing crazy, simple pivot tables etc) and it always takes forever to run.

Definitely. I've found pivots to be almost unusable. Even pivoting a single dataset with a couple hundred lines takes over 10 minutes to run. The dataset runs just fine on it's own. The most common need I've had is to group rows for transaction searches and wish there was a better option.