Eric Rockey's latest posting is all about one of the new data features in Visio 2007: the PivotDiagrams.
You can think of PivotDiagrams as similar to PivotTables in Excel.  They allow you to work with data where you want to see groups and subtotals.