How to keep field values in a straight table independent from dimensions and only depending on whether a pre set date falls between a date interval.

[cheburashka]

Hello,

For a better understanding of my question please have a look at the attached qvw.

Calculated dimension?

Set-Analysis?

_Koen

[danielrozental]

You can do set analysis or not, please find the sample attached.

[cheburashka · Accepted solution]

Thx for your almost perfect answer Daniel.

I made some final adjustments to make the solution more general and also cope with more Employees.

Extra notes on the solution can be found in the attached qvw.

Lessons Learned:

The TOTAL function should be used to make calculations in an expression independent from the dimensions in the chart.

Set-Analysis should be used to make calculations in an expression independent from the current selections.

Questions:

The solution without the Set-Analysis is most easy to read and understand. But which of both is best from performance point of view?

_Koen