Thread: Data Analyze - Prompt to find data using month as range (i.e from January to May)
View Single Post
 
Old 06-23-2024, 09:22 PM
jahidul jahidul is offline Windows 10 Office 2019
Novice
  
Join Date: Jun 2024
Posts: 1
jahidul is on a distinguished road
Default Data Analyze - Prompt to find data using month as range (i.e from January to May)
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 !
Reply With Quote