Anyways, you need to start from pivot data from "Edit Data source"
and add one calculated field
[Delta from 100%]
1-sum([Pivot field values])
Then combine two sheets on dashboard.
Hide header / title
addupto100_SM_9.3.twbx 28.2 KB
I did not think of that way.
I will try it out and get back with you.