Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parallel Period Reporting in Sales

Status
Not open for further replies.

rdoshi

Programmer
Jul 16, 2001
6
NL
Hi,

I want to have sales report in cross tab format where the
column I need to show as quarter like Q1, Q2,...and
row I need to show as Years like 1999, 2001...2001....and and middle cells would have '% of Growth Sales'.

Now my problem is that I need to get this sales profit amount comparetively to previos period i.e. for Q2 it would be = (Sales profit of Q1 - Sales profit of Q2) /Sales profit of Q1 and so on.

I dont find any function where I can get this parallet period type reporting. Can anybody help me?

 
You can't use the regular cross-tab to do percentages between columns. You have to create a 'manual' cross-tab using conditional totals. See my FAQ in the GENERAL formum on Common Formula examples. There is a description of the technique. Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top