Howisplay percents of unfiltered column in pivot

[chilly_bang]

I have a simple pivot with two columns: first column with URLs, second column with values. The values I display as % from column result (field value setting → display values as → % of column result - my Excel is in German, maybe I translate it wrongly) - the column sum is 100%.

My issue:

I.e. I filter out some URLs from the first column, which sum value is 20%. But the sum of the value column remains after filtering 100% and not 80%.

How can I calculate values as % from the unfiltered column result?

 

[GlennUK]

The percent is of the total showing, which is always 100%, and is as expected. There is nothing wrong - you just expect something odd - and that isn't happening. Why don't you drag the unwanted URLs together in the PivotTable, and then Group them, as say, UNWANTED, collapse the group - then the remainder will show, and still be part of an unfiltered total?