Hi All!
I am creating a fairly simple pivot table, but am finding it very time consuming due to having to change all the defaults. SO data in source is a summary each month for 3 fields for a individual store, located in a specific country. WHen I pivot I want data summed by country for each of those fields each month. SO I put the country in the Row label. THen I want to take the 3 monthly field list items (so there are 27 right now lets call them fields A,B,C for January through September) and add tehm to the sum Values field as a SUM. So it would sum for January-Field A in Country=Australia. Pivot would then 27 columns and number of countries in the rows... What I am finding though is
1)I can't select all the fields together and drag over to the values. Have to do it one at a time. I want to pick all the Field A's for the 9 months and put them together as they go in the field list so I can ultimately show trends month over month
and
2) WHen I do move each FIeld A over to the value field settings always defaults to COUNT. I want it to always default to SUM.
Can anyone help me figure out how to change defaults to help expedite this? Once I get it built I will just have to add 3 columns to the report each month, so no issue, but I have to do this for multiple channels, and it is kicking my butt right now.
Bookmarks