Hi,
I want to create Pivot chart but has to be in Grouped on basis of % values.
E.g. Suppose this is my data
Attribute Name Count Percentage Percentage1
A1 67810 100.00 100%
A2 600 90.00 90%
A3 640000 95.00 95%
A4 569000 80.00 80%
A1 1000 71.00 71%
A2 0 60.00 60%
A3 0 50.00 50%
A4 0 42.00 42%
A1 568000 35.00 35%
A2 456738 25.00 25%
A3 0 15.00 15%
A4 5000 0.00 0%
If I group value on Percetage column then it will show me correct chart, but i group the value on Percentage1 then it will show only one value at a time. Below Pivot for your reference
Row Labels Sum of Count
0-9 5000
10-19 0
20-29 456738
30-39 568000
40-49 0
50-59 0
60-69 0
70-79 1000
80-89 569000
90-100 708410
Grand Total 2308148
After grouping this pivot shows me all values, but if I group on Percentage1, it will show on evalue at time
Row Labels Sum of Count
0-10 2308148
Grand Total 2308148
Your help will be highly appreciated, upload file for reference
I want to create Pivot chart but has to be in Grouped on basis of % values.
E.g. Suppose this is my data
Attribute Name Count Percentage Percentage1
A1 67810 100.00 100%
A2 600 90.00 90%
A3 640000 95.00 95%
A4 569000 80.00 80%
A1 1000 71.00 71%
A2 0 60.00 60%
A3 0 50.00 50%
A4 0 42.00 42%
A1 568000 35.00 35%
A2 456738 25.00 25%
A3 0 15.00 15%
A4 5000 0.00 0%
If I group value on Percetage column then it will show me correct chart, but i group the value on Percentage1 then it will show only one value at a time. Below Pivot for your reference
Row Labels Sum of Count
0-9 5000
10-19 0
20-29 456738
30-39 568000
40-49 0
50-59 0
60-69 0
70-79 1000
80-89 569000
90-100 708410
Grand Total 2308148
After grouping this pivot shows me all values, but if I group on Percentage1, it will show on evalue at time
Row Labels Sum of Count
0-10 2308148
Grand Total 2308148
Your help will be highly appreciated, upload file for reference