Good morning,

I would like to help to solve this issue.

I have two fields, one named as “Functional Group” and the other “Split Functional Group”. Both have the same options to choose. Above I have a “Split Rate” and “Fiscal Cost Reduction”.

I already have a sum chart that shows me the fiscal cost reduction per functional group along time. However, now I need another that shows me:

If I don’t have a “Split Functional Group” and “Split Rate” filled, then the Functional Group has 100% of “Fiscal Cost Reduction”. But if I have, the “Split Rate” shows the % of the division. The first one will take 50% of the value and the other the rest.

But I need a graph that: if I select “CPM” (one option available in “Functional Group” and “Split Functional Group”), it will show me the sum of both fields: when it is the main and when it is the split.

What I have today:

Cumulative sum of “Functional Group”, already considering when have “Split Rate” or not.

([Measures].[Split Rate with due date]/100)*([Measures].[Fiscal Cost Reduction with due date on Maturity], [Functional Group].DefaultMember)

Cumulative sum of “Split Functional Group”.

((100-[Measures].[Split Rate with due date])/100)*([Measures].[Fiscal Cost Reduction with due date on Maturity], [Split Functional Group].DefaultMember)

Both together is the dashed line.

The problem: how can I create a filter to select one option (“CPM”) and show me the sum of both graphs?

I tried to write as explained as possible, but I’m available to explain more if necessary.

Thank you very much!!!