Alternative to "all or nothing" detach?

[#1]

Hi All!

Scenario:

I have 3-4 lists on a sheet:

• Customer Name
• Customer Region
• Calendar Year
• Calendar Month

I also have a couple of charts / tables / whatever.

I understand that I can "detach" one of my charts so that it doesn't "respect" the filtering action which occurs when a user makes a selection in Customer Name / Customer Region / Calendar Year / Calendar Month / Another Chart.

What if I want to only "semi-detach" it? For example, maybe I want my chart to only respect associations to Calendar Year and Customer Region, but ignore Customer Name and Calendar Month...Is there a way to accomplish that?

Thanks!

[hector · Accepted solution]

Hi, depending of your model, you can try this wit Set Analysis

if your expression is something like

Sum(Value)

change by

Sum({<CustomerNameField =, CalendarMonthField= >}Value)

so when you filter, these fields will be ignored

Rgds