Hi,
I have a pie chart thats taking data from one of the dataset. My dataset has around 7 columns. Columns-A,B,C,D,E,F,G
In Pie chart data under values- I am taking the count of two columns under values(= Count(A)+Count(B)). But for Category group i want to combine the two columns data as well column C and Column D. Can i combine the two columns data?
Thanks.
maybe create a calculated field in your dataset = Fields!A.Value + Fields!B.Value + Fields!C.Value + Fields!D.Value, and then use that calculated field instead of Fields A-D. (I do this if I want to lump a bunch of the fields together (say if they make up a really tiny percentage of the whole).
I tried calculated field but it does not work for my case.
My data is like below-
| A | C | B | D | E | F | G |
| Test | Ex-1 | Test | Ex-4 | | | |
| Test | Ex-2 | Test | Ex-5 | | | |
| Test | Ex-3 | Test | Ex-5 | | | |
i am doing count of A and B on the value property of pie chart. In the category group i want to combine C and D columns.
So the slices of pie should show count- 1 for Ex-1, 1-Ex-2,1 for Ex-3,1-Ex-4,2 for Ex-5 on every slice.