Search:

Type: Posts; User: bryanworkman; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    6
    Views
    133

    Re: Dynamic Average Selling Price Pivot

    That's right. For example, I have an account for Salaries, Vacations, Holidays, etc. and then I roll them all up into a group called Employee Compensation. I appreciate the ideas!
  2. Replies
    6
    Views
    133

    Re: Dynamic Average Selling Price Pivot

    Thanks! The only issue is that I would have to set up and manually manage all of the calculated items. I have 90+ accounts. I would need to create a set of calculated a set of calculated items for...
  3. Replies
    6
    Views
    133

    Re: Dynamic Average Selling Price Pivot

    I totally know what you mean. It seems simple enough. The first problem is that my data for the number of employees is in the same column, thus the same pivot field, as my costs. So there's no way...
  4. Replies
    6
    Views
    133

    Dynamic Average Selling Price Pivot

    I have racked my brain with a solution for this problem and can never seem to crack it. I have to calculate Cost Per Head (CPH) for several different slices of a data set consisting of >500k rows....
Results 1 to 4 of 4