Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Crosstab help
grather
Trying to understand these Crosstabs
I have it working just not exactly like I imagined and not like client wants.
Using a csv file
Name,Count,Percent
A,5,7.1
B,10,14.2
C,20,28.5
D,20,28.5
E,10,14.2
F,5,7.1
with this rptdesign file.
What I really want is to draw a chart.
I have this working
But trying to draw a data chart
Want it to look like similar to this
Name A B C D E F Totals
Count 5 10 20 20 10 5 70
Percent 7.1 14.2 28.5 28.5 14.2 7.1
But not really sure if I did it correctly.
I used a cross tab but had to put
Name and percent in the columns
The count in the summary so I could add a subtotal
But really want the count before the percent.
Hope all this makes sense
What is the right way to do this
Find more posts tagged with
Comments
bhanley
I think you may have tried to embed images in your post that cannot be seen. You are referring to examples that are not there. Can you upload the images as Thumbnails so I can get an idea what you are driving at?
grather
Sorry
I actually thought including the csv and the rptdesign would help.
Here is an image.
On my wanted output for this.
I even have more questions after this one I am sure
I thought it was a crosstab but not so sure anymore
Gary