While creating Bar in bar chart, we turn off the stacked marks so that both the bars will start from 0.

Drop Order Date to columns, Category to Rows, and Sales to Text.
Go to Analysis -> Totals -> Show Columns Grand Total
Graphical user interface, text, application Description automatically generated

Update Total All Using to Average:
Graphical user interface, text, application Description automatically generated

Table Description automatically generated

In the year 2012, the furniture sales were more than the average sales of that year.

Graphical user interface Description automatically generated

Explanation
Blend is the left outer join after aggregation at the level of granularity.

Find out how many gold medals each athlete won in the 2008 Olympics
Graphical user interface, text, application, website Description automatically generated

Drop Athlete to Rows and 2008 golds to the Text. Drop gold medals to the view. Your view will look like this:
Graphical user interface, text, application Description automatically generated

Now we need work on "won at least 4 golds in 2012 Olympics"
Drop years to filters and select 2012.
Drop Gold Medals to filter and mention 4 in range of values (as we need to find athletes who won at least 4 gold medals) Graphical user interface Description automatically generated

Final view:
Graphical user interface, text, application, chat or text message Description automatically generated