Show excluded values from a filter pane selection

[Sam_Thomas]

Hi 

I want to be able to show excluded values after a selection on the filter pane has been made, whilst also showing the values for the selection. 

For example, lets say I have Sales table and I have a Product column and a Price column. I want to show to metrics, one KPI to show the sum of sales for the selected product in a filter pane and another KPI to show the sum of sales excluding the selection made in the filter pane. 

So if the total sales figure is £1m, and the sum of sales for the selection are £100k, I would like to show one KPI with £100k and one KPI with £900k. 

Thanks

[Sivapriya_d]

Hi ,

Please check if below helps

to show the value for selections ==>Sum(sales)

to show the value excluding current selections==>=Sum({1-$}sales)

Thanks,