Best suggestion - don't use this method. Instead, use QuarterName([Close of Business Date]), or create a dual type containing the desired naming scheme as well as the underlying date.
If you must use this, you'll have to custom sort using something like Right(QuarterYear,4) & Left(QuarterYear,2).
Best suggestion - don't use this method. Instead, use QuarterName([Close of Business Date]), or create a dual type containing the desired naming scheme as well as the underlying date.
If you must use this, you'll have to custom sort using something like Right(QuarterYear,4) & Left(QuarterYear,2).
Thanks for reply. I want to show maxquarteryear sales in a table. I have created variable like Max( quarteryear) but it didnt help me.it is not showing max year quarter sales.Can you please help me on this
