Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Can someone please provide ideas for this.