June 26, 2009 at 5:04 am
Hi,
We have a requirement to show the Daily Sales of all Stores using Reporting Services - Matrix.
The layout of the report is attached.
We acheived our requirement using Matrix except getting the Day Total. We would like to sum up all the rows for a day to get Total Day level Sales. Also we would like to sum up and show the Grand Total.
Please provide your suggestions on how to get the Day Total .
Thanks,
Balaji.
June 26, 2009 at 12:39 pm
Balaji,
Is there a particular reason why you're using a Matrix instead of the tabular report? By looking at your attached document, I don’t see the need for it. You can easily group the days in a tabular report and show the subtotals and totals.
If you must use a Matrix, although this may not be the best way, you can do the subtotal and totals directly in your SQL query (obviously this doesn't apply if you're using a cube).
I hope this helps,
Eli
June 26, 2009 at 9:31 pm
Hi,
I dont have any specific reason to use Matrix. I thought we cannot acheive this using Tables as "Gross Sales, Net Sales and Tax are common for an Item but Revenues may be shared by more thanone partner. I dont know the way how to proceed with the tables to acheive this. Please let me know how to proceed with the Table/Matrix to acheive this requirement.
Thanks,
Balaji.
June 29, 2009 at 6:10 am
Yes - this can be done in a tabular report. Based on your requirements, you can place a combination of date, store, item, and partner into a group. Then you can use the SUM function at any of those group levels to retrieve the totals that fall under that group (such as day, store, item.. etc).
Hope that helps,
Eli
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply