asked on
Can a formula be added to a cross tab report to report a % of change of two values?
I have a cross-tab report that reports results of a quantity shipped and compares quarter over quarter (example: Q2 2015 to Q2 2016)
Is there a way to have the report take the value of each quarter and calculate the growth or decrease for each group and report as a percentage?
I have attached my report.
Samples-Shipped-Yr-over-Yr.rpt
Is there a way to have the report take the value of each quarter and calculate the growth or decrease for each group and report as a percentage?
I have attached my report.
Samples-Shipped-Yr-over-Yr.rpt
Crystal Reports
Last Comment
Joe Brown
ASKER
XI
but I also have 2011 and could use that instead if there is an advantage to that.
but I also have 2011 and could use that instead if there is an advantage to that.
ASKER
Here is the report in version 2011. I would like to have a column that can report % of change between the two years.
I was also wondering how I would get the data to sort in descending order by the Qty Shipped field for the most recent year (in this case 2016)
SO_Samples-Shipped-Yr-over-Yr.rpt
I was also wondering how I would get the data to sort in descending order by the Qty Shipped field for the most recent year (in this case 2016)
SO_Samples-Shipped-Yr-over-Yr.rpt
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you. I will try this when I can circle back to this project.
mlmcc