Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.