08-28-2014 01:23 PM
HI I a have a question on a transpose
i have a table that looks like this
BRanch. Name. Date. Compliance.
a1. Apple. 08/25/14. Reported
a2. Apple. 08/25/14. Reported
a3. Mustard. 08/25/14. Not reported
a3. Mustard. 08/26/14. Reported
the transpose table I would like it to look like
branch. Count. total Reported. Not reported . Count. total Reported. Not reported
a1. 1. 1. 1
a2. 1. 1. 1
a3. 1. 1. 1. 1. 1. 1
The count / total will change as there is more entries thank you again
08-28-2014 01:47 PM
This looks more appropriate for a report than a dataset.
You show a "count" but what is it counting? It looks like you might be counting distinct levels of Name but you don't say that. Same with Totat, total of what?
Also example data should provide data that would give count/total values greater than one as many approaches that work for singleton types of data may not work when there are multiple values.
08-28-2014 02:56 PM
your right sorry my question was incomplete
What the table should look like is like this not reported and report is sum of occuerance ....
apple 2. 39. 22. 7.
Uniq count (Not reported) Not report. Reported Unqui count (reported)
A1. 1 34. 12. 3
a2. 1 5. 20. 4
a3. 0. 0. 0
I hope that helps
09-03-2014 06:46 PM
The data looks like this
ID. COMPLIANCE. Date. Code
A1. yes 08/14/14. A
A2. Yes. 08/15/14. B
A1. No. 08/15/14. A
a2. No. 08/14/14. B
a1. Yes. 08/16/14. A
I Need the date to be column I need the compliance to be sum an breack out of yes an no... I need the count of ID ... Thanks for your assitance