I'm trying to figure out how to create a summary measure table which is calculated off my original source table. The idea is to summarise (in %) the counts of 2 or more columns but allow that summary to be affected by selection made in chart. attached
Please see attached my (crudely) drawn diagram which I hope better shows what I'm trying to do.
There is no need to anything in the script, You can load data as is, and build calculated table and chart on the front end. See attached. Warning: I'm using ValueList() function here. If you have a large application (hundreds of MB), it is risky for performance. In small or midsize app it will be fine.