Summary Display Type:
v

Quantity
AbsoluteVariation
Category Name
Sales Person
BeveragesCondimentsConfectionsDairy ProductsGrains/CerealsMeat/PoultryProduceSeafoodGrand Total
QuantityAbsoluteVariationQuantityAbsoluteVariationQuantityAbsoluteVariationQuantityAbsoluteVariationQuantityAbsoluteVariationQuantityAbsoluteVariationQuantityAbsoluteVariationQuantityAbsoluteVariation
Andrew Fuller1069  709-36086315491047645-26570257297-4058605636055
Anne Dodsworth519  493-26365-12863927474-5651356141-944043632670
Janet Leverling1310  670-64013466761308-38887-421525-362327-198147911527852
Laura Callahan1308  634-674989355726-263688-38419-269411-87383275913
Margaret Peacock1572  1252-32015352831455-801000-455921-79558-36315059479798
Michael Suyama778  254-524393139728335313-415180-1333721925091373527
Nancy Davolio1607  651-95613336821525192422-1103544122492-5212387467812
Robert King948  486-462742256940198320-62039575268-1275552874654
Steven Buchanan421  149-272340191918578213-705378165224-1543931693036
Grand Total9532  5298-423479062608914912434562-45874199-3632990-12097681469151317
Description
C#
VB
ASPX

Rather than displaying raw summary values in cells, you can show how these values correlate to values in other cells, and so perform a range of data analysis. For instance, you can display the differences between summaries in the current and previous cells, or the percentage of a column's or row's total.

Use the Summary Display Type combo box to choose summary display mode, and see how this changes values in every second data column.