Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to filter my ' Pivot table' chart's expression output to show the total sum only for the customer listed within a certain other field (all possible values). The amount of the filtered customers could change (after a rebuild), so a fixed list of values for filtering as show in other examples within the community is not an option.
I could solve this at first when adding the field ListOfCustomersToBeFiltered as a dimension and use ' Surpress all values Is Null'.
Disadvantage is that the customers number would also show and I just want to show the totals of these filtered customers list:
I thought it could be solved with an expression that should be like :
= Sum({< MyCustomers = {ListOfCustomersToBeFiltered} >} Weights)
but that does not work. Any suggestions if this is possible in this 'easy' way ?