I have a Pivot table that I am trying to combine the side item totals into one total. Right now one side item goes from 07 to 93 (called Code) and the other side item goes from 07A1 to 93A4 (called Altcode). I would like all the 07A1 (etc) together and if it is blank for it to go under 07 (etc). The amount I want to compute in Facts is called Completetime (for Code and Altcode). We have tried "if" statements and CountNull but it does not give me the totals I want. Any suggestions?
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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Beginner using Brio
- Thread starter morgan06
- Start date