Need Calculated Field for each month column

Hi all,

I have a pivot table with 2 columns of data per row. I'd like to replace the 2 columns with a single column that totals the 2 columns. I've tried using Calculated Fields, but they're not totalling correctly. The first Calculated Field, called Test, returns all zeroes. The second Calculated Field, Test2, returns all 2's. In the attached file, starting col.I you can see 1. Current Pivot Table, with the 2 Calculated Fields not working. 2. Possible Output is a mockup of how the monthly totals should look, and 3. Desired Output is what I'm trying to get to in order to produce a chart. Any suggestions appreciated. TIA...

Originally Posted by rorya

Since it looks like you always have either Car or Van/4x4 for each row, remove all the value fields you have currently and just add one of the other fields like Name, which will count by default. (Calculated fields always Sum, so you'd need to load your data to the data model and use measures otherwise).

That's perfect, thanks rorya.

Originally Posted by Pepe Le Mokko

A small adjustment to your data layout solves the problem

Thanks Pepe Le Mokko, but that's not quite the solution I'm looking for. I just want the total figures for the month, not the figures for Car or Van/4x4. I'm a little embarrassed at how simple the solution was, as suggested by rorya.