Hello. I have a table of plots, the farmer name, area, and plant type. Each record is a different plot.
I wanted to create a summary table, per grower per plant type, summing up the total area across all the plots.
This solution:
Total per Grower =
Calculatetable(
SUMMARIZE(
new_plotinformations,new_plotinformations[Grower],new_plotinformations[_new_variety_id_value],new_plotinformations[Total Planted Ha Converted],new_plotinformations[_new_country_id_value],new_plotinformations[Plantation Status],new_plotinformations[statecode],new_plotinformations[_new_licensee_value],new_plotinformations[_new_company_id_value],new_plotinformations[Production Status]
),
new_plotinformations[Plantation Status] = "Commercial")
Did not return a total for each variety per grower. Instead, it simply pulled each plot record, which is what the source table already had.
I tried the below, but it didn't work. Can someone please advise how I would do a summary table?
SUMMARIZEcolumns(new_plotinformations[_new_company_id_value],new_plotinformations[_new_variety_id_value], new_plotinformations,new_plotinformations[Grower],new_plotinformations[_new_variety_id_value],new_plotinformations[Total Planted Ha Converted],new_plotinformations[_new_country_id_value],new_plotinformations[Plantation Status],new_plotinformations[statecode],new_plotinformations[_new_licensee_value],new_plotinformations[_new_company_id_value],new_plotinformations[Production Status]
),
new_plotinformations[Plantation Status] = "Commercial")
I would appreciate some advice, if people could let me know what I did wrong here. I should also mention that the reason for doing this in the first place is that I need to show growers and their varieties, provided their total sum of each variety is greater than 1.0. So if a grower has 5 plots each with .5 area of PlantTypeA = include them all. If a grower has 2 plots with planttypeB, but their total sum is .8 - don't include this variety at all.
