Please share a sample workbook or dataset
See attached please. Simply what I want at basic level is :
20/06/2016 20/06/2016 20/06/2016 21/06/2016 21/06/2016 22/06/2016
20/06/2016 - 3
21/06/2016 - 2
22/06/2016 - 1
I want to report on a count of data based on number of records filtered by date created.
Sample.xlsx 8.3 KB
Have you tried using SUM(Number of Records) or Count (Date). With Month (Date) as one of the dimension and above as Measure, and if I have understood your question correctly then it should get what you're trying to achieve.