How calculate the percentage?

[#1]

Hi all,

I have one scenario:

load * Inline
[
year,month,visits
2007,1,20
2007,2,30
2009,1,30
]

I want to calculate the pecentage, it looks like this:

Year Month Visits Percentage

2007 1 20 20/50

2007 1 30 30/50

2009 1 30 30/ 30

It means how many percentage the month visits occupied based on the same year.

I want to use pivot table to achieve, how to write this expression?

Thanks.

[tresesco]

yes, you are right. any dimension you can use with TOTAL. and its not a part of set analysis.