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
Joe BrownIT ManagerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
You will have to do it in CR2011.  CR XI doesn't have the capability to create added formulas like that.  It was added in CR2008.

Try using the group sort expert.  You may have to create a formula that tests for the year and returns the value if current year otherwise 0.
If Year ({AR_InvoiceHistoryHeader.InvoiceDate}) - Year(CurrentDate) then
    {AR_InvoiceHistoryDetail.QuantityShipped}
Else
    0

Open in new window


mlmcc
0
 
mlmccCommented:
What version of Crystal are you using?

mlmcc
0
 
Joe BrownIT ManagerAuthor Commented:
XI
but I also have 2011 and could use that instead if there is an advantage to that.
0
 
Joe BrownIT ManagerAuthor Commented:
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
0
 
Joe BrownIT ManagerAuthor Commented:
Thank you. I will try this when I can circle back to this project.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.