6 Replies Latest reply on Aug 21, 2018 10:49 PM by Vijay Kulkarni

# Dimension Calculation/Table Calculation

I'm looking to create a calculation based off a table or dimension.

In this example, compliance would be "Y"/Sum of (Y+N+Null). The values Y, N, N/A and Null are the same for all of these dimensions:

I've attached the packaged workbook.

thanks!

• ###### 1. Re: Dimension Calculation/Table Calculation

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

• ###### 2. Re: Dimension Calculation/Table Calculation

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

1 of 1 people found this helpful
• ###### 3. Re: Dimension Calculation/Table Calculation

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

Thanks - however, this makes all values a %, versus taking only the Y over the sum of all.

• ###### 5. Re: Dimension Calculation/Table Calculation

Hi, Amirah

Hope this helps

ZZ

• ###### 6. Re: Dimension Calculation/Table Calculation

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