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?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.