Forum Discussion
Anonymous
6 years agoNot applicable
Allocated budget per user
Hi,
I have a requirement where i need to calculate :
- cost per user per product
- sliced by Empl and Date tables
Per User cost per product is monthly budget per product divided by count of users from Usage table.I tried to created count of users from Usage table and created a calculated column in Budget table that provided per head cost per product based on headcount measure fromo USage table but not knowing how to get to fulfil the requirement in an optimum way.Hence ,pls show and tell how to get to the requirements.Attaching the sample model examplehttps://drive.google.com/file/d/1dCpvsmTsNvsJ_PzYMnyEsIcKyeeXMKY6/view?usp=sharing :
1 Reply
- AnonymousNot applicable
Can someone please provide ideas for this.