Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning
where to use the expression in a Setanalysis should make a comparison between two fields
I'll explain the formula that I wrote
if the second operator specific month the formula works
Sum ({1 <[MeseSerie] = {'January'}>} [Sales]) / 1000000
but if I have a field Meseselezione not know how to put it in the second operator I tried with:
Sum ({1 <[MeseSerie] = {[Meseselezione]}>} [Sales]) / 1000000
but it does not work 😞
thanks
Andrea
May be something like this:
Sum({1}Aggr(If(MeseSerie = Meseselezione, Sales), MeseSerie, Meseselezione))
May be something like below
=SUM({<Customer = {"=MeseSerie = Meseselezione"}, MeseSerie = {'Jan'}>}Sales)/1000000
Change Customer to YourFieldName