If I'm understanding the issue correctly, you're basically just needing to filter this pivot table on a dimension value, which is straightforward enough.

Without access to the Data Load Editor or Data Manager, you have two options to achieve this:

Use the Filter option in the dashboard editor

This option is the easiest, but is limited to Qlik Cloud. If you're unsure about whether you're using Qlik Cloud, just look at your URL when you're logged in -- it should be something like YourCompany.us.qlikcloud.com.

To filter, just open your app, go into Edit mode, and then make sure that Advanced Mode is toggled off:

Then, find the Filter option at the bottom-left part of the screen. Simply Add the BUSINESS UNIT dimension, choose the Other value, and then select the Exclude option. Done!

Use a Set Expression

If you are not using Qlik Cloud and are, thus, using Qlik Sense Enterprise on Windows or Qlik Sense Desktop, you can use a Set Expression to achieve this.

TLDR

In your pivot table, replace your [BUSINESS UNIT] expression with this: =Aggr(Only({<[BUSINESS UNIT]-={'Other'}>} [BUSINESS UNIT]), [BUSINESS UNIT]). Then Uncheck the Include null values option.

Explanation

If you're not familiar with Set Analysis, it's basically a way to "build in" selections into a measure or chart. In practical terms, it's a way we can filter values. Set Analysis is meant only for measures ("aggregations"), but we can use a simple trick to use it on dimensions, too.

In your pivot table, replace your [BUSINESS UNIT] expression with this:

=Aggr(Only({<[BUSINESS UNIT]-={'Other'}>} [BUSINESS UNIT]), [BUSINESS UNIT])

A few things are going on here:

• We are using the Only() function here because, like I mentioned above, we need to use a measure for Set Analysis to work. This function returns a value if as long as only one value is available.
• Normally the above behavior wouldn't be helpful here because we have several Business Unit values we want to return, so we use the Aggr() function to group Only([BUSINESS UNIT]) by [BUSINESS UNIT] itself.
• Finally, we add the actual Set Expression, {<[BUSINESS UNIT]-={'Other'}>}, which is basically saying "give me the set of [BUSINESS UNIT] values, excluding the value 'Other'". The exclusion operator is that minus sign before the equal sign.

The last step would be to uncheck the Include null values option for the [BUSINESS UNIT] field.