I have a database containing all sales i make for different client.
I'd like to make an overview page with a running total field for all sales in the first quarter, another for the second quarter etc.
So in the end i can see how much i made each quarter. This field shoudl self update upon new sales.
How can i do this?
Found a way around by doing a search for all 1st quarter fields and copying total invoice value to a container field.
Very unhandy and i have to fire a script each time a update...
Any help is appreciated very much!
quarter calculation Div(Month(salesDate)+2;3) //this maybe better containing year data
sum summary sum of sales
Then you can make overview page as the layout with only sub summary part grouped by quarter. Find records in this year, sort them in quarter.