I have data base called "Employment Date" it take from SQL database. I already load the "Employment Date" on script. By using: Date("Employment Date") Month("Employment Date")
Question is how do I able to show/present total every specific month by column in expression. It should like this below:
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
- JAN will showing total all employment at first month(JAN). - FEB will showing total all employment at first month(FEB). - MAR will showing total all employment at first month(MAR). - and onward to Dec.
Meaning I do not need to select field month to show/presenting total employee at that particular month. We want it as automatically show on expression on table. The reason for this we need to sum 3 months and divided by 3 to get average employee. What is the correct function/expression can I use?
