I have very simple situation but don't know how to define subtotatls creating MDX calculation.
There is such situation displayed bellow:
View Complete Post
View Complete Post
my table has div code, inventory date, landfill name , no of tonnes and total tonnes for a particular division and month tht the user selects
i need to display data such as show below as a sample:-
Division Month day Landfill Name No Of Loads Total tonnes000 August 1 Niagara 10 5000 August 2 Niagara 10 5000 August 3 Niagara 10 5000 August 4 Niagara 10 &nb
Please help. I have an SSRS report showing weekly sales per store from 2007 to current. It should show only last 3 weeks of sales, YTD and Total Since 2007
Week -8/28/10 Week - 9/4/10 Week - 9/11/10 Total
YTD Total Since 2007
102 89 157
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 :)