Percentage calculation

[fml55555]

I have three columns...

1. I want to populate the second coulmn with a constant number (say 10000)

2. I want the third column to be the percentage of the second column to the first column. How can this be achieved?


(These are lists ). I am working on OLAP model.

Thanks you!

[Francis aka khayman]

hmmm, is this a trick question?

1. drag the first column to your list.
2. drag a data item in your list in the second column, give it the value you want (say 10000).
3. drag a third data item in your list. here do the percentage calculation: [first column]/[second column] (or whatever)
4. format the data.

-- for #3, you can also select the first and second column, then click on the Calculation (green icon) button in the tool bar. select the formula you need.