#### tourgis2000

##### New Member

- Joined
- Sep 3, 2008

- Messages
- 48

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