Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
For a better understanding of my question please have a look at the attached qvw.
Calculated dimension?
Set-Analysis?
_Koen
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
You can do set analysis or not, please find the sample attached.
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