Number of responses by Survey question - Last 6 months
Summary:I want to show the distinct values for a survey question in first Column ,and then in remaining columns we want to show number of responses based on survey question in particular months(last 6months).
Q1: Vechicles (choices : Bicycle,bike,car)
and survey responses are submitted.
Bicycle - Number of responses in april is 5,Number of responses in march is 10,number of responses feb-15
bike -number of responses in april month is 20,no of response in march is 25,(upto last 6 months)
car-number of responses in april is 35,(upto last 6 months)