Calculate % of Units
-
I have the following report I'm working on that has Fiscal Year and is broken out of by months. The Customer wants to have units per month then % of Total for Fiscal Year, Revenu, % of FY revenuse. I have the Revenu and Units summed but I'm not having any luck with the % of Total FYE numbers. Here is a picture of the Report
*** Could anyone offer some assistance please!
- Stephen crocker - Monday, April 17, 2017 7:23 AMI have the following report I'm working on that has Fiscal Year and is broken out of by months. The Customer wants to have units per month then % of Total for Fiscal Year, Revenu, % of FY revenuse. I have the Revenu and Units summed but I'm not having any luck with the % of Total FYE numbers. Here is a picture of the Report
*** Could anyone offer some assistance please!You are not likely going to get any help here unless you can provide some actual details. Just posting a picture of your report designer and saying "I'm not having any luck" is not setting your question up for success. In fact, it is setting it up for failure. I keep looking at your picture and wondering what the actual question is. Help us help you by giving us the details needed to be able to help.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ - Sean Lange - Monday, April 17, 2017 7:36 AMStephen crocker - Monday, April 17, 2017 7:23 AMI have the following report I'm working on that has Fiscal Year and is broken out of by months. The Customer wants to have units per month then % of Total for Fiscal Year, Revenu, % of FY revenuse. I have the Revenu and Units summed but I'm not having any luck with the % of Total FYE numbers. Here is a picture of the Report
*** Could anyone offer some assistance please!You are not likely going to get any help here unless you can provide some actual details. Just posting a picture of your report designer and saying "I'm not having any luck" is not setting your question up for success. In fact, it is setting it up for failure. I keep looking at your picture and wondering what the actual question is. Help us help you by giving us the details needed to be able to help.
Never mind, I figured it out.
Thanks for looking Though
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply