Hello team!
I have a data source that has data by marketplace (country), and I am trying to get the representativity % of a field (value) based on the group row, not the column. So for instance, I have marketplaces 4 and 5. Instead of getting a percent of total for them that would sum 100% altgother, I need that within marketplace 4, I have a SUM of 100% and within marketplace , a sum of another 100%, meaning that I need the percent of total to be based on whatever I put as a row (markeplace, item name, etc).
In the picture above, I should have for every marketplace row, the sum of 100% (that would comprise the sum of YES and NO together). Right now you can see that row marketplace 4(first line) is giving 71.11%, out of the whole total (all marketplaces)
Right now the calculate field formula is as below:
Net Concessions coverage % =
percentOfTotal
(sum({net_concessions}))
Could you please help on that?
thanks