I have a requirement as below.
I need to show in chart like,
1.How many customers have value in only Column1 but not in Column2 and 3
2. How many customers have value in only Column2 but not in Column1 and 3
3.How many customers have value in only Column3 but not in Column1 and 2
4.How many customers have value in only Column1 and Column2 but not in 3
5.How many customers have value in only Column1 but not in Column3 but not in 2 ans so on.
6.How many customers have value in all the columns.
Could you please help in completing this requirement.
The above solution is most helpful.
I my application I have 5 fields to be used and based on the above I have to write several combinations and more over I need to show them in either a bar Chart or any other chart.
Is there any other work around for this either in back end or Front end.
There is no specific chart requested by the user but they wanted to see the data in better visualization.
It could be any chart other than Straight table or Pivot table.
The below is what user is expecting.
The Blocks represents the Column1 to Column5
The colored block indicates there is a value and empty block indicates no value.
The numbers represents the customers.
40 Customers has values in column1 and column2 only.