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!
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.