% of total

[Carlaf_93]

Good morning,

i've got this situation.

I would like to get the % of Valore/total Valore for every year.

if i do --> sum(VALORE)/sum(total VALORE) it gives the % not for year but for all the table...

What do i need to set?

Thanks

[vamshi2i]

Hi Carlaf_93,

Try this: 

sum({<Year>} VALORE) / sum(total <Year> VALORE)

[Carlaf_93]

Thanks,

but this desn't work

[Carlaf_93]

Sum({<[DATA.autoCalendar.Year]>}VALORE)/
Sum(total {<[DATA.autoCalendar.Year]>}VALORE)