Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to use the following in a set analyse ?
Aim is to neglect the value(s) selected for the [Schedule quater], but instead use the value(s) for the field [close quarter]
Sum( {$< [Schedule Quarter]=, [Close Quarter]=[Schedule Quarter] >} [Sales])
Or may be this:
Sum({$<[Schedule Quarter]=, [Close Quarter] = p([Schedule Quarter])>} [Sales])
This could work, at least the syntax is ok, have you tried it?
Or may be this:
Sum({$<[Schedule Quarter]=, [Close Quarter] = p([Schedule Quarter])>} [Sales])
I tried and it didn't work
This is perfect.
Thx