In few cells there are more than one criteria and when I generate pivot ; it counts as a single criteria . Pls refer to below snip :
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
| Data : | ||||
| Criteria | Student ID | |||
| I like apple I like banana | 2011 | |||
| I like tiger | 2012 | |||
| I like to bike | 2018 | |||
| I like apple | 2019 | |||
| Pivot : | ||||
| Row Labels | Count of Student ID | |||
| I like apple | 1 | |||
| I like tiger | 1 | |||
| I like to bike | 1 | |||
| I like apple I like banana | 1 | |||
| Grand Total | 4 | |||
| Issue : | ||||
| Criteria "I like apple " is showing as 1 ; Pivot is unable to count this criteria appearing in Top row 4 . | ||||
| Top Row 4 is coming as a separate like. I want to achieve that it shows 2 against this criteria. |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
