Set Identifier - Quick Question?

[#1]

I'm creating a pivot table that will have Item Categories and Items along the side, and Warehouse Locations across the top. I want to show a sum of sales in the table. The Item Categories and Items along the side should respond to filter selections, but the Warehouse Locations across the top should stay static -- i.e. always show all locations, even if the user has one or more selected.

I've tried a number of things with the set identifier, but don't see a way to call out a specific field. I'd rather not use a bookmark. I feel like I'm missing something. Can someone help? Thanks.

[#2]

You need to use TOTAL qualifier to avoid the Warehouse filters

SUM(TOTAL <Item_Category , Item_Name> SALES)

[#3]

Thanks. That doesn't work. The Locations still respond to the filter.

[sunny_talwar]

May be this:

{<[Warehouse Location] = >}

[julian_rodriguez · Accepted solution]

Hello

Try SUM({$<[Warehouse Locations] = >} Sales)

This expression will ignore the selections on the field "Warehouse Locations"

Regards

[maxgro]

try

sum({$ <[Warehouse Locations]= >}  sales)

[jagan]

Hi Brian,

Try like this in Set Analysis

Sum({<WarehouseLocation=>}  Sales)

WarehouseLocation= will ignore the selections in WarehouseLocation field.

Note: WarehouseLocation and Sales with your actual field name.

Regards,

Jagan.

[#8]

That seems to work. I swear I tried it and it did not. Thanks everyone.

[jagan]

Hi Brian,

If you got the answer please close this thread by giving Correct and Helpful answers so that it helps others in finding the answers easily.

Regards,

Jagan.

[Anonymous]

Hi

Try this: Sum({$<WarehouseLocation=>} Sales)