
1. Re: Dimension Calculation/Table Calculation
Zhouyi Zhang Aug 20, 2018 9:12 PM (in response to Amirah Thompson)Hi, Amirah
Please find my solution attached. below are the steps
1st, pivot your data as below
using percent of total pane down table calculation
Hope this helps
ZZ

Medical Analysis_v10.2.twbx 311.1 KB


2. Re: Dimension Calculation/Table Calculation
Vijay Kulkarni Aug 20, 2018 9:37 PM (in response to Amirah Thompson)Hi Amirah,
Here is workbook with Compliance calculation depending upon the dimension user selects. Hope this is what you are looking at. Let me know.
Vijay

Medical Analysis_v10.2.twbx 266.2 KB


3. Re: Dimension Calculation/Table Calculation
Amirah Thompson Aug 21, 2018 6:59 AM (in response to Vijay Kulkarni)Vijay,
Thank you for the updated calculations, however, the formulas are still taking into account N and N/A into the numerator.
Example, advise to call 911 should be: 20/94. System is taking 56/94. (20+17+19 = 56). I'm not sure where the values are coming from, as the calculation is built to only take into consideration the Y values.

4. Re: Dimension Calculation/Table Calculation
Amirah Thompson Aug 21, 2018 7:00 AM (in response to Zhouyi Zhang)Thanks  however, this makes all values a %, versus taking only the Y over the sum of all.

5. Re: Dimension Calculation/Table Calculation
Zhouyi Zhang Aug 21, 2018 6:33 PM (in response to Amirah Thompson)
Medical Analysis_v10.2 (1).twbx 304.0 KB


6. Re: Dimension Calculation/Table Calculation
Vijay Kulkarni Aug 21, 2018 10:49 PM (in response to Amirah Thompson)Hi Amirah,
Here is updated workbook. Please refer Solution sheets. I suggested to use a parameter to select dimension instead of developing separate sheet for each dimension. You can add all dimensions which you want in the parameter Select Dimension and calculated field Selected dimension.
Let me know if it works for you.
Vijay

Medical Analysis_v10.2 V1.twbx 278.0 KB
