1 Reply Latest reply on Aug 2, 2017 4:01 PM by Patrick A Van Der Hyde

# Calculate a "field calculed" based on the value of filter (Filter created with others "field calculated")

Hello,

I would like to know if it's possible to calculate a filed based on the value of filter, knowing values are also field calculated.

Ex :

 Indicator1 Indicator2 Indicator3 Indicator4 Indicator5 1 0 2 4 1

If I select in filter "Indicator1" and "Indicator3" the value of the field calculated "TOTAL" = 1+2 = 3

If I select in filter "Indicator1" and "Indicator4" and "Indicator5" the value of the filed calculated "TOTAL" = 1 + 4 + 1 = 6

I think the first step should be create a parameter including these field calculated "Indicator1", ""Indicator2", "Indicator3", "Indicator4" and "indicator5".

Many thanks for your help^,

Arno

• ###### 1. Re: Calculate a "field calculed" based on the value of filter (Filter created with others "field calculated")

Hello Arnaud,

Are the values for each indicator separate types of measure values or are they only distinct within the Dimension of "Indicator" .

If you have a workbook to share, we might be able to better understand the desired outcome and be able to assist.

Thank you

Patrick