Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to show the value of the budget in a graph.
I want to show the value of month 1 of the budget in month 1 of production, i.e. when mes=mesbudget.
I'm using the following condition:
if(Mes=MesBudget,
Sum({$<[Hierarchy 4]-={'Accessories','Services'}>}totalBudgetValue))
But it only works when I select both variables in the filter.
How can I show the value and filter only by year?
Sum({$<Mes={'MesBudget'},[Hierarchy 4]-={'Accessories','Services'}>}totalBudgetValue)