So I have sheet 3 with parameters selected month and selected week wherein the values are reflecting appropriately, but in sheet4 for every Select Week value the data values in the cross tab is changing, however if select month the values doesn't reflect according to the month.
Not sure if that is working in Select Week, but not in Select Month.
Attached my workbook for reference.
답변 1개
@Kavya Ravi Prakash Hi Kavya
The issue is because when you filter on Month, the date range is only in the year 1900 and not 2023. The Select Month Parameter contains dates from the year 2023, which is not matching with what is present under the month group.
I hope that answers your question.
