I created a table that is similar to the one below:
Now I wrote a measure with sumx, that take values from a column An(|n is indicated by parameter) and Cm(same for m) and calculate (A-C)*P. Then i created a table with Country, Material and measure and filtered that measure is always greater than 0. Now i want to create a measure that will sum up all my values from measure(greater than 0) and i would like also to do a table with summarizing value with measure for every country.
Is it possible? should i build table in other way, or do some other measures? Please let me know.
Thank you in advance for responce.
Should be possible. See if this Quick Measure, Measure Totals, The Final Word should get you what you need:
Proud to be a Datanaut!