Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Goodmorning everyone
I inserted a text field with a set formula analisys that should not be considered and should be independent of the selection applied on TipoAttività.
the formula is:
= sum ({1 <[TipoAttività] = {'F'}>} [Budget in €] / 1000000)
in doing so if the dashboard select the TipoAttività = 'E' text field continues to correctly display the sum of the budget for data with TipoAttività = 'F'
Syntax 1 <[....] it rules out all current selections, while I would need to consider the selection of another date field.
how can I use the setanalisys to not only consider the field selections TipoAttività? how can I add in SetAnalisys operators also control the series = CurrentSelection (Series)?
Thanks for collaboration
Andrea
There are two approaches:
{$<Field1=>}
will start with current selections and remove the selection in "Field1".
{1<Field2=P(Field2)>}
will start with no selections (1) and add the possible values of "Field2" in the current selection as a selection.
Note that you can have an additional Set expression inside the P() function.
HIC