2 Replies Latest reply on Jul 7, 2016 11:02 AM by Manideep Bhattacharyya

# Counting and Finding sum of combination of Dimensional attributes

Hi everyone,

I got a field in Excel:

``Treament Status  ITITSDUSDSDSDUSD ``

I need to use a calculated field to find a Percentage of total using this mathematical formula, based on the number of times certain dimensional attributes appears in the column i.e. Count:

% of R = [Count(SD)+Count(IT)]/[Count(Total of everything in Treatment Status)]

I know how to use the COUNT and SUM functions but I'm trying to connect the dots here.

Thank you!

• ###### 1. Re: Counting and Finding sum of combination of Dimensional attributes

Do you know LOD?

Here i keep the total of Sale using Fixed clause.

SUM([Sales])

/

SUM({FIXED: SUM([Sales])})

This is how i'd count:

Sum(If [Sub-Category] = "Phones" then 1 Else 0 End)

You have to adapt it.

1 of 1 people found this helpful
• ###### 2. Re: Counting and Finding sum of combination of Dimensional attributes

Hello - There are many ways to solve this. This one is the easiest and simplest by creating calculated fields.

Thanks

Manideep

1 of 1 people found this helpful