Using TOTAL get percentage rate in a pivot chart

[#1]

This is my first post to the forum and I'm hoping someone else has attempted the same type of thing. I've attached an example file that was created with 8.2.

I'm trying to combine the information in the two first charts to look like that last chart. My problem is that when I use 'Suppress When Value Is Null' in the 3^rd chart I lose the values I need to get the proper total in order to get the correct % rate. The last chart has the correct values to get the right percentage, but I don't want to display the last row.

Thanks for you assistance.

Jonathan

[disqr_rm · Accepted solution]

See enclosed. Is this what you are looking for?

[#3]

OAD * INLINE [
CustNo, CustAge, AgeSinceAdd, TransID, Amount
1, 1, 1, 1, 10
2, 1, 5, ,
3, 1, 1, 2, 20
4, 1, 5, ,
5, 1, 1, 3, 30
6, 2, 2, 4, 40
6, 2, 2, 5, 50
6, 2, 2, 6, 60
7, 2, 5, ,
8, 2, 1, 8, 80
8, 2, 1, 9, 90
8, 2, 1, 10, 100
8, 2, 1, 7, 70
9, 2, 5, ,
];

INNER JOIN

LOAD * INLINE [
AgeSinceAdd, AgeSinceAddDesc
1, 1 Week
2, 1 Month
3, 3 Months
4, 6 Months ];

[#4]

Rakesh,

Worked Perfectly! Thanks!

[Anonymous]

Very nice, saved me some troubles. However, add a total and it looks odd (blanks)?

/Nicolai