Set-expression

[Mynona]

Hi!
How should I create a table that contains, for example the following columns:

Articles
Cost center
Sale
Total sales

I want to be able to filter by time period, item and cost center. No matter how I filter, I want total sales to show for the items shown by the filter made. When I try to enter set expressions for total sales using the set identifier {1}, total sales are displayed as I wish, but also all other items  and cost centers are displayed since total sales has the set expression {1}. 

How to combine selection on article and/or cost center for one or more specific periods and show only the articles for the selection, but that total sales are shown for only these?

[RafaelBarrios]

hi @Mynona 

by using {1} you are ignoring all selections

you can specify to ignore especific selections by using

sum({< ignored_field1, ignored_field2 >} amount)

so if you select a date it will considere it

hope this helps.

best

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 

[Mynona]

Thank you! With a few adjustments I got the expression I wanted.