Hi All,
I'm using CRXI.
I created two stacked bar charts and inserted on the GF which is grouped by Name.
So first chart will show the percentage for each qtr which as follows:
2007q1 2007q2 ...............
100% 0
100% 0
0 100%
----------------------------------------------------
Total: 2/3 * 100 1/3 * 100 = 33.33
= 66.66
----------------------------------------------------
Second Chart:
calculation of % should be based on the number of records from first graph (from above chart in 2007q1 there are two records in which one record as child record)
so second chart output should be as follows:
2007q1
100%
0
-----------------------
Total: 1/2 * 100 = 50
-----------------------
where "1" is record with child and "2" is total number of records from first chart for 2007q1.
My question is whether its possible to get the percentage based on the number of records from the first graph.
I'm using CRXI.
I created two stacked bar charts and inserted on the GF which is grouped by Name.
So first chart will show the percentage for each qtr which as follows:
2007q1 2007q2 ...............
100% 0
100% 0
0 100%
----------------------------------------------------
Total: 2/3 * 100 1/3 * 100 = 33.33
= 66.66
----------------------------------------------------
Second Chart:
calculation of % should be based on the number of records from first graph (from above chart in 2007q1 there are two records in which one record as child record)
so second chart output should be as follows:
2007q1
100%
0
-----------------------
Total: 1/2 * 100 = 50
-----------------------
where "1" is record with child and "2" is total number of records from first chart for 2007q1.
My question is whether its possible to get the percentage based on the number of records from the first graph.