Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help With Running Totals

Status
Not open for further replies.

vega83

Programmer
Jun 12, 2008
141
US
Friends I need your hrlp,
Below is the sample data

June July Aug

103 1 1 0
105 2 4 6
104 1 1 1
104 1 1 1

I did running total based on data
June July Aug
103 1 1 0
105 2 4 6
104 1 1 1

I want to do total summary

But how do i do total summary based upon month?
 
Do summary based upon groups and then suppress group header and arrange subtotals of these groups on group footer
 
Youe mean report footer?, I need grand totals
 
Group is based on each month

June,July,Aug,etc.
 
Your running totals so far are reset on change of whatever field has results like 103,104,105. Create new running totals that have reset: never.

-LB
 
That is right I have created formula If month = 1 then then count else 0.Then i did running totals on this formula on change of upi and no rest. It works!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top