Show percentage of total while filtering out certain values

[Anonymous]

Hello all,

I am working on a dashboard where I want to show the sales of specific products (thus filtering out the product types I am not interested in) in percentage of the total sales. I made an easy table to explain my problem:

The original table of the product sales looks like this:

Product      Sales     Percentage
Airplane      10          10%

Bike             40          40%

Boat            15          15%

Car              35          35%

Total          100        100%

Now comes the problem. I only want to visualize the sales of airplanes and cars. However, I would like to keep the same sales percentages as visualized in the original table. When I filter out the sales of bikes and boats the table looks like this:

Product     Sales     Percentage

Airplane     10         22,23%

Car             35         77,77%

Total          45         100%

As you can see, the sales percentage of airplanes changed from 10% to 22,23% and the sales percentage of cars changed from 35% to 77,77%. This is not what I want; I want the sales percentage of airplanes to stay 10% and the sales percentage of cars 35%. 

Is there a method which makes it possible to filter out certain product groups without letting the sales percentages change? I am really looking forward to your solutions!!

Greets Ruben

[parry2k · Accepted solution]

@Anonymous in your formulat to calculate %, add ALL function so that to perform % calculations it is not filtering data.

[Anonymous]

Thank you for your quick reply!