You asked about pivot tables (video)

re: You asked about pivot tables (video)

emerald77 — Tue, 19 Apr 2011 15:46:28 GMT

There are two pivot table capabilities I wish Microsoft would incorporate in the next release of Excel: the ability to display subtotals for calculated fields, and the ability to display “grand” subtotals for inner row labels (i.e., fields) below the Grand Total row.

re: You asked about pivot tables (video)

tbergman — Mon, 28 Mar 2011 17:07:02 GMT

I love pivot tables and, in most ways, they're the perfect reporting tool. There's just one feature that would complete them and save our users form having to go outside the pivot to answer some simple business questions.

Imagine a typical revenue report with customer info, product info, revenue etc. Try to answer the question "How many customers bought something in November?" or "How many products did I sell in November". These questions revolve around distinct customers and products as the same customer may have many purchases and the same product gets sold many times. These questions cannot be answered in a pivot. Yes, I can drill down and filter on unique records only. Or put the field in the row area and count the rows it takes up but these are both awkward and not in keeping with the beauty of a pivot table.

I'd like to see, and can't imagine this would be hard to develop, a "CountDistinct" choice added to the Sum, Count, Average etc. choices.

This is not the first time I've asked for this but I figure maybe there are new people listening.

Thanks,

Tom

re: You asked about pivot tables (video)

Frank — Fri, 25 Mar 2011 16:36:59 GMT

I use pivot tables regularly, is there a way to select the default settings data/values to be formatted a specific way? For example; I always want my data to sum (not count) and I always want my values to be numbers (1,234) with no decimal places.

I find it rather cumbersome to have to make the necessary changes on several columns of data.

re: You asked about pivot table (video)

smabres — Wed, 23 Mar 2011 15:23:04 GMT

Very nice and simple thanks so much!