Page 1 of 1

Cross-Tab Percent instead total

Posted: Fri Jun 19, 2009 4:13 pm
by mantas
Is it possible to change the total to the difference percentage between two value?

For example: I have a list of schools on 'Rows', the years on 'Columns' and their profit for each year in 'Summary'. I want to compare how much, in percents, they have 'grown' or 'shrinked' and show it on the 'Total' column.
Is it possible with Cross-tab? If not, any ideas how to do it?

Thanks

PS: Sorry about my english, i don't speak english very well :)

Cross-Tab Percent instead total

Posted: Mon Jun 22, 2009 1:26 am
by Jan
Hello,

Try to use ShowPercents property of cells.

Thank you.

Cross-Tab Percent instead total

Posted: Sat Jun 27, 2009 9:13 am
by mantas
Jan wrote:Hello,

Try to use ShowPercents property of cells.

Thank you.
No, that's not my problem, i was trying to calculate the percentage between two values.

I already made it on VB with datatables and i had a hard time trying to do it ^^

But thanks for the answer and your time :)