tusharmehta
New Member
- Joined
- May 12, 2014
- Messages
- 34
Hello Everyone,
I herewith posting one example in which I have two tables:
1 Transaction table
2 Range Table
<tbody>
</tbody>
My questions is how to fill the Range from Range table to Transaction table automatically using PowerPivot calculate or other functions?
Thanks in Advance.
I herewith posting one example in which I have two tables:
1 Transaction table
2 Range Table
Transaction Table | Range Table | ||||||
Sr. No | Product | Amount | Range | Range | Start | End | |
1 | Pr1 | 100 | ?? | 0-100 | 0 | 100 | |
2 | Pr2 | 200 | ?? | 101-200 | 101 | 200 | |
3 | Pr3 | 150 | ?? | 201-300 | 201 | 300 | |
4 | Pr4 | 110 | ?? | 301-400 | 301 | 400 | |
5 | Pr5 | 300 | ?? | 401-500 | 401 | 500 | |
6 | Pr6 | 450 | ?? | 501-600 | 501 | 600 | |
7 | Pr7 | 122 | ?? | 601-700 | 601 | 700 | |
8 | Pr8 | 1000 | ?? | 701-800 | 701 | 800 | |
9 | Pr9 | 232 | ?? | 801-900 | 801 | 900 | |
10 | Pr10 | 265 | ?? | 901-1000 | 901 | 1000 | |
1001-1100 | 1001 | 1100 | |||||
1101-1200 | 1101 | 1200 | |||||
1201-1300 | 1201 | 1300 |
<tbody>
</tbody>
My questions is how to fill the Range from Range table to Transaction table automatically using PowerPivot calculate or other functions?
Thanks in Advance.