tourgis2000
New Member
- Joined
- Sep 3, 2008
- Messages
- 48
Hi all,
I'm a beginner to PowerPivot, and I don't really know how to ask my question, so any help would be greatly appreciated.
I have a table of values with two columns:
Column A = Items
Column B = Position of Item (values of about 1-15 but could be greater)
I want to produce a measure that (1) calculates the number of Items by position and (2) multiplies that result against the position of the item. An example might be:
<tbody>
</tbody>
The result I'm trying to get to is:
<tbody>
</tbody>
I can create this in an ordinary pivot and then use calculations to get the answer but how can I do all of it in a PowerPivot measure?
Thanks,
Martin
I'm a beginner to PowerPivot, and I don't really know how to ask my question, so any help would be greatly appreciated.
I have a table of values with two columns:
Column A = Items
Column B = Position of Item (values of about 1-15 but could be greater)
I want to produce a measure that (1) calculates the number of Items by position and (2) multiplies that result against the position of the item. An example might be:
Item | Position |
Apples | 1 |
Apples | 3 |
Apples | 1 |
Pears | 2 |
Oranges | 6 |
Oranges | 6 |
<tbody>
</tbody>
The result I'm trying to get to is:
1 | 2 | 3 | 4 | 5 | 6 | Total | |
Apples | 2 | 1 | |||||
Pears | 1 | ||||||
Oranges | 2 | ||||||
Total | 2 | 1 | 1 | 0 | 0 | 2 | =((2x1)+(1x2)+(1x3)+(0x4)+(0x5)+(2x6))/6 |
<tbody>
</tbody>
I can create this in an ordinary pivot and then use calculations to get the answer but how can I do all of it in a PowerPivot measure?
Thanks,
Martin