Hi
I am using date picker extension for selecting date. Based on which the data will be displayed in pivot table.
Now I have an issue. If there are jan, feb, to Dec month's data. In date picker, only if I select the last date of a month (31st jan) the january month's data needs to get displayed.
Months are stored in 'Month'
Values for each month is stored in 'Amount' -> it is a measure
Can someone please help.