SPD: I have two lists: Customers and Services. Customers is the "Parent List", and may have multiple values in the "Services" list, but should only have one per year. The entire report is restricted to one year, so that should not be an issue. I have my
dvwp all set up, and am able to display one line per customer, and group as needed. My only sticking point is that I cannot get the subtotals or totals for a field in the subview. The field I need to subtotal on is "TotalMoney".
I am thinking that an XPath Formula field is the way to go, but I am not getting anywhere. I feel I'm on the right track, but am stuck. Something like this:
sum(/dsQueryResponse/ChildList/Rows/Row[@ParentIDSavedinChildList= /dsQueryResponse/ParentList/Rows/Row/@ID] AND [/dsQueryResponse/ChildList/Rows/Row[@GroupedField= /dsQueryResponse/ParentList/Rows/Row/@GroupedField)/@TotalMoney
I know that is not in the correct format. I'm not sure how to throw an "and" clause in there, or even if it's possible. Thoughts? The only ideas that I have kind of stink. May a separate report for each grouping. Create a calculated field for each potential
grouping (a total nightmare).
Thoughts? Please? I'll give you chocolate or beer - your choice :)
View Complete Post