topic Set Analysis Expression Help in App Development

Set Analysis Expression Help

sona_sa — Tue, 21 Dec 2021 21:56:36 GMT

Team,

Now suppose if I make any selection in Year Month or Plant, Figure not affected in Pivot Table. So need expression for the same. Please find the attached QVW for more reference.

Thanks

Re: Set Analysis Expression Help

Seyko — Tue, 11 May 2021 20:30:44 GMT

Hello,

I'm not really sure to understand exactly what do you want! Below, this is your expression:

sum({1<[Plant]=,[Date]*=>} Value)

PS : You've a synthetic key in your data model. Be sure to correct this to avoid wrong link between tables

Re: Set Analysis Expression Help

sona_sa — Wed, 12 May 2021 04:06:49 GMT

Please ignore my expression.

I have two list box, I just want, If I make any selection in my List Box, In Pivot Table - It should not to change or affect on my selection of Year Month or Plant.

Hope you got my concern.

Thanks Seyko.