Scenario: DVWP that looks at 3 columns in a library
CreatedBy Name Status
I want to group first on "CreatedBy", then on "Status". But I want the Status groupings to display horizontally, not beneath the first grouping as is the default behavior for a DVWP. I also want to show the count for each status grouping. I've played around with the XSL, many variations but cannot get this to work. Here's what it looks like: a) default DVWP behavior, and b) how I'd like it to look. Any help would be greatly appreciated!
A) Default DVWP behavior (2 groupings, first user expanded: count($nodeset) for status included
-Username1 -Status: Not Started (2) test1.docx test2.docx -Status: Completed (1) test3.docx +Username2 +Username3 +Username4
B) How I want it to look (first user expanded: count($nodeset) for status included
Status:Not Started Status: Completed -Username1 2 1 test1.docx test3.docx test2.docx +Username2 0 1 +Username3 3 0 +Username4 2 2