Hello Friends,
I have two filters like Calendar Years and Fiscal Period, the calendar years should show the data of Jan to Dec data and the fiscal period should show the data From Oct to Sep.
I have created in the script like the following and I used a list box control as a filter, my requirement is always the table data should display 12 months of data I tried with "Always one value to be selected" but this is not helpful I go for Fiscal Period.
Is any solutions for this like a swich Calendar to Fiscal and Fiscal to Calendar.
YearName(InvoiceDate,0,1) as [Calendar Years]
YearName(InvoiceDate,0,10) as [Fiscal Period]
Regards
