This should be doable, but the structure of your data is important to answering the question. Any chance you can post some sample data or a packaged workbook?
Its doable. I had to create some calc's to separate out the Categories first and then do the percent change - catch I have to show at least 1 decimal place in order to be correct.
See attached sample. If you find this helpful then please mark this response correct. Thank you.
Subtotal in Rows-AP.twbx 551.7 KB
Thanks Ankit, Would you be able to provide calculations here? I can't open the workbook you sent.
Which version of Tableau Desktop are you using? - the one I provided earlier was built in 10.5
Here you go: Create the below 7 calculated fields to achieve what you are looking for
IF [NPS Cat1] = 'Detractor' THEN 1 ELSE 0 END
IF [NPS Cat1] = 'Passive' THEN 1 ELSE 0 END
IF [NPS Cat1] = 'Promoter' THEN 1 ELSE 0 END
SUM([Detractor]) / (SUM([Number of Records]))
SUM([Passive]) / (SUM([Number of Records]))
SUM([Promoter]) / (SUM([Number of Records]))
NPS Score %
[Promoter %] - [Detractor %]
If you find this useful then please mark so others can benefit from it.
Ankit, I am using 10.1
I get this message: "This file was created by a newer version of Tableau. Please contact Tableau Software to upgrade your version."
Ankit, that was very kind of you to explain the solution with screen captures. I really appreciate your effort. Thank you!