Fabio Lima
New Member
- Joined
- Jul 19, 2012
- Messages
- 3
Guys,
this has been making me insane for the last few days, can anyone give me hand. I need the % of a grand total for every row in my pivot table. HOWEVER I need calculate a few things before that. Bear with! The example below gives me the total volume of a product by two months broken down by region and cluster. I need to divide each cell in a column by its column grand total, and then subtract the result of "this month" by "last month", and that must be in only one DAX measure.
<tbody>
</tbody>
Help me guys!
Cheers!
this has been making me insane for the last few days, can anyone give me hand. I need the % of a grand total for every row in my pivot table. HOWEVER I need calculate a few things before that. Bear with! The example below gives me the total volume of a product by two months broken down by region and cluster. I need to divide each cell in a column by its column grand total, and then subtract the result of "this month" by "last month", and that must be in only one DAX measure.
| Region & Cluster | Last Month | This Month |
| Region A | 152 | 151 |
| cluster 1 | 126 | 124 |
| cluster 2 | 26 | 27 |
| Region B | 182 | 186 |
| cluster 1 | 84 | 92 |
| cluster 2 | 98 | 94 |
| Region C | 44 | 55 |
| cluster 1 | 21 | 25 |
| cluster 2 | 23 | 30 |
| Grand Total | 378 | 392 |
<tbody>
</tbody>
Help me guys!
Cheers!
