Making a selection (filter) of fields on just one expresstion in a diagram

[#1]

Hi!

Yesterday I got some great help here so I try again.

I have a diagram (pivot) where I what one of the extression to select several values.

If I only whant onwe valu then this works:

=((sum({<[PD] = {'$(vCurrentPD)'}>} Belopp)))

But I whant a range of "PD" from 'startPD' to 'vCurrentPD'

=((sum({<[PD] = "From 'startPD' to vCurrentPD'     Belopp)))

Any ideas?

Thank you

Jonny

[#2 · Accepted solution]

Hi Jonny,

something like the below should work

Sum({$< PD = {'>=$(startPD) <=$(vCurrentPD)'}>} Belopp )

hope that helps

Joe

[#3]

Works perfektly, Thanks

[#4]

no worries, glad to be of help, maybe check out this thread for a bit more info on set analysis

Set Analysis: syntaxes, examples

Joe