Cross-Tab Percent instead total

mantas · Post by **mantas** » Fri Jun 19, 2009 4:13 pm

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

Post by **Jan** » Mon Jun 22, 2009 1:26 am

Hello,

Try to use ShowPercents property of cells.

Thank you.

mantas · Post by **mantas** » Sat Jun 27, 2009 9:13 am

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