Can a formula be added to a cross tab report to report a % of change of two values?

Joe Brown
Joe Brown used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
What version of Crystal are you using?

mlmcc
Joe BrownIT Manager

Author

Commented:
XI
but I also have 2011 and could use that instead if there is an advantage to that.
Joe BrownIT Manager

Author

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
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
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
Joe BrownIT Manager

Author

Commented:
Thank you. I will try this when I can circle back to this project.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial