
1. Re: sum/subtract rows/fields and and create computed column for the sum results
Hima vardhan Reddy Pavuluri Nov 21, 2016 6:17 AM (in response to bikash rawal)Hi , Try this :
Create a calculation like below :
{fixed : sum(if [Row Labels]='Promoter' OR [Row Labels]='Detractor') then 1 else 0 end}
Use this calculation in View.

3. Re: sum/subtract rows/fields and and create computed column for the sum results
bikash rawal Nov 21, 2016 11:29 AM (in response to Hima vardhan Reddy Pavuluri)Hi Hima,
I have updated the question, please update if you have solution to this.
Thanks,
Bikash

4. Re: sum/subtract rows/fields and and create computed column for the sum results
bikash rawal Nov 21, 2016 1:44 PM (in response to Hima vardhan Reddy Pavuluri)I got the result but it's adding not subtracting.

5. Re: sum/subtract rows/fields and and create computed column for the sum results
Hima vardhan Reddy Pavuluri Nov 21, 2016 10:04 PM (in response to bikash rawal)Please attach sample workbook and Expected result as a screenshot in excel sheet !

6. Re: sum/subtract rows/fields and and create computed column for the sum results
bikash rawal Nov 21, 2016 11:22 PM (in response to Hima vardhan Reddy Pavuluri)Attached on the original post above. Pleas look into that. diff is the calculated field with; WINDOW_SUM(SUM(if [NPS]='Promoter' OR [NPS]='Detractor' THEN 1 ELSE 0 END)) formula.
It works doing something like sum([a])sum([b]) but with referencing the corresponding field it doesn't looks to be working.
Please go through the workbook and and let me know if any questions. I hope you get the solution to this.

7. Re: sum/subtract rows/fields and and create computed column for the sum results
Hima vardhan Reddy Pavuluri Nov 22, 2016 12:15 AM (in response to bikash rawal)You have attached twb file, so couldn't open your workbook .