Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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!
Thank you! With a few adjustments I got the expression I wanted.