Data Analyze - Prompt to find data using month as range (i.e from January to May)

[jahidul]

Hello,



So I have a dataset from where i want to find monthly data for a certain period ! Let's say from January, 2017 to June, 2017.
Whenever I use a prompt in Data analyze !

Example: Let's say prompt is - Value of 'FANTA' by 'Month' 'Jan to Jun' of 'Year' '2017'

The data that is shown is for Jan 2017 and Jun 2017
But not for Jan 2017, Feb 2017, Mar 2017 ....... June 2017.
( Check the screenshot )

Snipshot.PNG

What should be the prompt to find out the data ranging from Jan to Jun 2017

Thank you !

[Alansidman]

You could filter the year for 2017 or you could build a Pivot Table and filter for the year and product. It would be easier to demonstrate if you uploaded a sample file instead of picture. We cannot manipulate data in a picture.