Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Just click and drag until you get the format you want
here is a file with it done
Hi,
you have to add the show partials sums in the presentation tab
The partial sums shows totals, does not repeat the same columns to the right.
Sorry, but adding the second expression you have what you want.
Just click and drag until you get the format you want
here is a file with it done
Yes but I should drag the lines not the columns as I was doing.