Skip to Content
0
Aug 23, 2023 at 11:39 AM

How can we create a custom filter using dropdown value in sac optimized design mode

127 Views Last edit Aug 24, 2023 at 09:46 AM 2 rev

Hi Folks,

image.png

User need to filter period based on dropdown value. If user select last 3 month in the dropdown value It should filter and give last 3 month, like that user need to filter based on the following option

  1. calendar year,
  2. current month,
  3. last 3 month,
  4. last 3 year,
  5. NZ financial year(only for Nz)
  6. old financial year
  7. company financial year FY23
  8. company financial year YTD
  9. company last financial year
  10. Pervious month
  11. Qtr1
  12. Qtr2
  13. Qtr3
  14. Qtr4
  15. Rolling 12 month
  16. Yesterday.

In Phocas reporting tool there is an Inbuild option can any one please help me how can achieve this in optimized design mode in sac

Regards,
Thayu.

Attachments

image.png (4.2 kB)