Pivot Tables

[#1]

I have something like this in raw data:

Full Text Reason Code	Days Bucket	Amount
101 - Cash Application Issue	16-30 Days	10
101 - Cash Application Issue	16-30 Days	20
101 - Cash Application Issue	16-30 Days	30
101 - Cash Application Issue	16-30 Days	40
101 - Cash Application Issue	1-15 Days	50
101 - Cash Application Issue	1-15 Days	15
101 - Cash Application Issue	1-15 Days	25
100 - Please Select	16-30 Days	35
100 - Please Select	1-15 Days	2
100 - Please Select	16-30 Days	3
100 - Please Select	16-30 Days	4

That I want to display like this in a report table:

		(Count Days Bucket)		(Sum of Amount)
Row Labels		1-15 Days	16-30 Days	1-15 Days	16-30 Days
100 - Please Select		1	3	2	42
101 - Cash Application Issue		3	4	90	100

The first part of having the (Count Days Bucket) Columns is done. Now I need to repeat those columns on the right, for the Sum of Amount.

Also I want it done in a way that if I add new rows with new periods of days, it automatically add's a new column to the report table, like in Excel.

Message was edited by: Miguel Domingos 2013-10-14 at 14h11m GMT

[bbi_mba_76]

Hi,

you have to add the show partials sums in the presentation tab

[#3]

The partial sums shows totals, does not repeat the same columns to the right.

[bbi_mba_76]

Sorry, but adding the second expression you have what you want.

[rustyfishbones · Accepted solution]

Just click and drag until you get the format you want

here is a file with it done

[#6]

Yes but I should drag the lines not the columns as I was doing.