Hi Jose,

You can drag the Product onto the Rows shelf and then drag Quantity there as well (should default to SUM).

Then you can either put Storage Location onto the Filters  and make this a “Multiple Values” filter

OR

make a parameter titled Include/Exclude where you can then use in a calculated field:

If Exclude then Storage Location <> “Other” ELSE True END

Hope this helps! Sorry I can’t provide screenshots currently - commuting home! Happy to later.

Jose,

Here's a quick calc you could use with a Parameter showing "Include" and "Exclude" as the options:

IF [Parameter 1] = "Include" THEN [Quantity]

ELSEIF [Parameter 1] = "Exclude" THEN (IF [Storage Location]!= "Other" THEN [Quantity] END)

END

-Wesley

If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

Hi, Jose

Please find my solution attached.

Hope this helps

ZZ

Create a Boolean parameter called [Include Other] and use a calculation something like the following:

IF [Storage Location]<>"Other" OR ([Storage Location]="Other" AND [Include Other]) THEN [Quantity] END

Just drag this calculation on to the shelf.

Dan

Sure!

Method 1 using Quick Filter:

Method 2 using Parameter:

Put this on Filters where = TRUE:

Do you have a workbook? Works fine in one data source - didn't know you were doing a blend.

Hi Jose Salazar,

I understand now. So, even if product doesn't have data in the storage table, you want to see it.

You are correct - you'll encounter issues when doing a blend then. Is there a reason you can't join datasets prior to bringing them in?

Doing this should help you get the final view you're aiming for:

New fields:

CF_FilterStorage:

IF [PA_ExcludeOther]

THEN [Storage Location]<>"Other" OR ISNULL([Storage Location])

ELSE TRUE

END

CF_StorageDisplay (done to show blank string rather than writing Null):

IFNULL([Storage Location], "")

CF_Quantity (done to show 0 instead of empty cell):

ZN([Quantity])

Hope this helps!

Hi, Jose

Please see the steps below.

1st, create a Boolean parameter

2nd, create a calculation field

3rd, drag calculation field to filter and right click to add to context

Hope this helps

ZZ