Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005-2015 : Report Design  
Message Icon Topic: Crosstab column comparison Post Reply Post New Topic
Author Message
Infoscrin
Newbie
Newbie
Avatar

Joined: 21 Jun 2017
Online Status: Offline
Posts: 1
Quote Infoscrin Replybullet Topic: Crosstab column comparison
    Posted: 06 Jul 2017 at 4:13am
Dear all!

I am new to Crystal Reports as a collegue of mine left the company and I got to do the whole reporting with Crystal Reports 2013.

What the reports should show is the following:

Our sales wants to compare the costumer per month from two different years, to see:
  • e.g. if costumers bought something in Mai 2016 and not in Mai 2017(lost costumers) or
  • if costumers bought something in Mai 2017 and not in Mai 2016(new costumers)

I tried to achieve this with a crosstab, but i always get a mixture of both, lost and new costumers...

I've created a filter for the years and months, added the month to the groupheader and added the year to the columns of the crosstab afterwards.
The row consists of the costumer name and the employee that was in charge. As a group result i added the sum of the money.

I don't know if this is enough information for you... If you need anything, please ask :/

Thank you very much in advance for your help!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.078 seconds.