Disregard filter for some data in table (Set-analysis?)

[#1]

I have a table showing the following data:

Number of produced units
Production hours
Hours/unit

The unit data comes from the orders and the hours from General ledger. There is no direct linking between this data, but by using Date as a dimension it is possible to get interesting data.

I do however have a problem. The users wants to have Cost Center and Resource as filters. In the General ledger the hours are stored per cost center and resource. The problem is that if select something in the filters, the produced units always show 0, since the orders have no connection to Cost Center and Resource.

Can I in any way, perhaps via Set-analysis, make "Number of produced units" show the total amount of produced units, disregarding the Cost Center and Resource filters?

[#2]

Hi

Set analysis would do this, if I assume you have two simple expressions like this:

=Sum(ProdHours)

=Sum(HoursPerUnit)

Let's further assume that your field names for Cost Centre and Resource are CostCentre and Resource and that those are the fields selected, you should then change your above expressions like so:

=Sum ( $ { < CostCentre={"*""}, Resource={"*"} > } ProdHours )

=Sum ( $ { < CostCentre={"*"}, Resource={"*"} > } HoursPerUnit )

So, the set analysis is taking current selections, but removing any selected filters on Cost Centre and Resource.

This should do it for you.