3 Replies Latest reply: Aug 1, 2014 6:51 AM by Joseph Simmons

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

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

• Re: Making a selection (filter) of fields on just one expresstionin a diagram

Hi Jonny,

something like the below should work

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

hope that helps

Joe

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

Works perfektly, Thanks

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

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