I have table data having column Product and Place, which has string values.
Requirement is to show the data for each Product in a separate List where each List Header should show Product Name with Count of rows matches of record Like ProductName(NumberofRecords) with Place also all rows should show count of records repeated in the table.
Sample Data as Below :
TableName Id Product Place 1 Apple Kashmiri 2 OrangeNagpur 3 OrangeSpain 4 Tomato Italy 5 Orange SouthAfrica 6 AppleAmerican 7 AppleIndonesian 8AppleArgentina 9AppleItaly 10AppleKashmiri 11AppleKashmiri 12AppleKashmiri 13AppleKashmiri 14OrangeNagpur 14Orange Nagpur 14Orange Nagpur 15Apple Indian 16Apple American 17Apple American 18Apple American 19Apple Argentina 20Apple Argentina 21Orange Spain 22Orange SouthAfrica
Result should be Like in different List or a Visual Table in a Single Column for each Product Records :
1st list should as below ============= Apple(15)-->Header of Table Header in Visual in Report Pane ---------------- Kashmiri(5) -> row American(4) -> row Indonesian(1) -> row Argentina(3) -> row Indian(1) -> row Italy(1)