Hello All -
I need to allocate a set admin fee ($5500) per quarter across the rows in my pivot table (product categories) relative to the quantity of products sold. So, let's say for simplicity, 4 product categories this quarter, each with 100 products sold. The admin fee allocation would be $13.75 per product (400 products sold in that quarter * $13.75 = $5500). Previous quarter had 5 product categories, with various quantities sold, but the admin fee for that quarter still needs to equal $5500.
How could I translate this into a measure?
Thanks!
I need to allocate a set admin fee ($5500) per quarter across the rows in my pivot table (product categories) relative to the quantity of products sold. So, let's say for simplicity, 4 product categories this quarter, each with 100 products sold. The admin fee allocation would be $13.75 per product (400 products sold in that quarter * $13.75 = $5500). Previous quarter had 5 product categories, with various quantities sold, but the admin fee for that quarter still needs to equal $5500.
How could I translate this into a measure?
Thanks!