Hello,
I am Trying to make a calculation where I calculate the current number of members
I have a cube with the following
fact table with
membershipid --- joindate --- leavedate (if any)
When browsing my cube the idea is that i can see and drill down to the amount of members at a given year,month,date.
so The leavers have to be substracted from the members but on the right date.
Hope you understand what I intend to do here 🙂