2 of 2 people found this helpful
I hope i understood your ask properly. I've tried to recreate the table you had asked for. Based on the parameter on the right, 'Region Select' the Sales1 column picks up the sales of that particular region and the last column gives you the difference. For example, in this case, Central region has 2.9MM sales, East has 8.3 MM; hence the difference is -5.3 MM.
How did i do this?
1. I created a parameter to choose region
2. Create a Calculated field ' Sales 1' - this creates another column 'Sales 1' in the dataset and assigns the Sales value if the IF condition is satisfied (the region and the region parameter has the same value); else it assigns the value of 0 to the Sales 1 column.
In order to use this value for all the regions, you can use LOD 'Exclude' - this will exclude the Region column while performing the calculation
3. Create another calculation - SUM([Sales]) - sum([Sales1]) and drag this as the last column
Here you go!!