Hi,
I have created a report Template which looks like below,
<<[ખાતા પ્રકાર]>> | Total | 0 | ||
તારીખ | નામ | વિગત | પ્રકાર | ફાઈનલ રકમ |
<<Start: ORDERBY([Related Cashs], [Date])>><<[Date]>> | <<[Name]>> | <<[Detail]>> | <<[Type]>> | <<[Amount]>><<End>> |
I want to add filter function where it will extract only those entries which fall between two dates (Start and End date)
For that I have created new sheet named as "Date" which contains details mentioned below Cell B2=Start Date, C2=End Date,
Detail | Start Date | End Date |
Date | 1-Aug-2023 | 31-Dec-2023 |
I have used this formula but it's now working. Can someone please help me to find the error. or show me the correct expression (function)
<<Start: ORDERBY(FILTER("Related Cashs", AND([Date] >= [Date].[Start Date], [Date] <= [Date].[End Date])), [તારીખ])>><<[Date]>>
User | Count |
---|---|
17 | |
11 | |
6 | |
5 | |
5 |