4 Replies Latest reply on Jun 19, 2017 6:38 PM by Zhouyi Zhang

# Level of Detail with Aggregated measures

Hi,

I am trying to create a level of detail calculation to find the proportion of units sold for each category at the agent, supervisor, and location level.

I am also trying to calculate the baseline or total average using level of detail calculation.

I am having some trouble with this and any help is appreciated.

• ###### 1. Re: Level of Detail with Aggregated measures

Hi, Tamid

Is this something you are after?

to your 2nd question, not quite sure what do you mean total average, can you explain more?

ZZ

• ###### 2. Re: Level of Detail with Aggregated measures

Hi Zhouyi,

For the second part I want to take the average of proportion I think. I wasn't sure if just doing AVG(%) would be enough or if I have to use LOD considering how the table is set up.

Not sure if I am getting the desired answer for the first one with the calculation you are showing.

To elaborate I want the table to ultimately look like below when I do the % calc

 Date Category Supervisor Location Agent ID Agent Name Sold Daily Total Daily Proportion 1/17/2017 Furniture Moore Orlando 1 DIXON 10 15 0.667 1/17/2017 Office Supplies Moore Orlando 1 DIXON 5 15 0.33 1/17/2017 Kitchen Supplies Moore Orlando 1 DIXON 0 15 0
• ###### 3. Re: Level of Detail with Aggregated measures

I think what I am struggling with is, is drilling the proportion down to each category for each agent and location.

• ###### 4. Re: Level of Detail with Aggregated measures

Hi, Tamzid

Based on your feedback, I updated my calculation as below

From the screen shot, the proportion is the same as you expected.

Please let me know if you have further question

ZZ