• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Monthwise sum

hissam78

Active Member
Dear all,
i want to sum up the qty by month. somebody can help me? word file is attached. i have created a date wise footer section but i don't understand how to create a month wise sum section.

thanks
 

Attachments

JMR

VIP Member
If your table(s) in your BSVW have a dedicated column for month and year, you can create a level-break footer section on the month column changing (sort by year, month) with both sorts checked for level breaks.

If your table(s) do NOT have month and year as separate fields, you will need to perform the level-breaking logic yourself. This should not be too complicated. Sort by date. Extract the year and month for every record read. If either value changes from the prior values, perform a custom section that outputs the totals for the prior values (manual level-break footer). You will need to tally the totals yourself.
 
Top