December 12, 2013 at 10:32 am
I have the following two grouping on my report.
Row Groups
[(table1_StoreName]
-(table1_Details_Group)
I am running a report that lists store locations by state code. The user is required to select a state code as a parameter (eg CA, California) before the report runs. when the report runs, all store locations within that state will populate the report. Each state has several stores and each store will have 1 or more employees. Each employee will have sales in dollars. I am attempting to total the sales revenue by state, store, and employee.
I have successfully summed up the total sales revenue for each state and each employee, but i am not able to total the sales revenue for each store. Each time I use the "Add Total" on the Row Group, I get the total for each employee.
How should i group the data such that i can get totals for Store and each employee?
December 12, 2013 at 12:48 pm
Ok, my grouping hierarchy was out-of-whack...has been corrected.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply