The user wants to see if there is a way to add a two additional column (Calculated columns) to data table like below table.
Market | Total | D1 | D2 | Total D | Percentage D1 | Percentage D2 | percentage Total D
Source 10 3 3 6 ?? ?? ??
Target 15 4 9 13 ?? ?? ??
Total, D1 and D2 are coming as a count from aggregation columns from index .
Not sure how to generate percentage of D1,D2 and total D .
Can someone please help here