Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Chart from a cross tab Post Reply Post New Topic
Author Message
rlassalle
Groupie
Groupie
Avatar

Joined: 09 Aug 2012
Online Status: Offline
Posts: 57
Quote rlassalle Replybullet Topic: Chart from a cross tab
     Posted: 17 Jun 2015 at 5:59pm
Hi there, I need your help. I made across tab which row are years and columns headers are the name of the 12 months. there are number counted as values. I need to make a stack chart with the year as X axis and the values in the columns segmented by each months.
e.g cross tab
     Jan     Feb     Mar     Apr     May     Jun     
2012     33     45     65     56     44     85     
2013     22     32     45     74     105     99     
2014     102     96     100     66     88     90     
2015     45     66     60     12     60     75     

a second axis with the total by month has to be added.
                                   
Thanks                                   
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 18 Jun 2015 at 3:45am
so I assume you have one date field in your source that you have applied two formual fields to get the year value and the month value
for your stacked chart try
insert a vertical stacked bar chart in your report header or footer
for data tab
on change of: select the year value then also select the month value
 
in teh show values select the field you are summarizing and set that to the type of summarization (count/sum/avg) you need
IP IP Logged
rlassalle
Groupie
Groupie
Avatar

Joined: 09 Aug 2012
Online Status: Offline
Posts: 57
Quote rlassalle Replybullet Posted: 20 Jun 2015 at 3:19pm
Thank you so much for your answer, It works. Can you help me with the second part include the PVT column total to show in the chart as another value.

Thank for your help
IP IP Logged
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