Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: Calculated Column Circular Error need alternative solution

    Hoping to bump this one, as I'm still struggling to find a solution. Maybe it will help if I put my problem a different way:

    My desired end pivot table is a list of customers with their current...
  2. Calculated Column Circular Error need alternative solution

    Hello,

    I unfortunately/fortunately learned the hard way yesterday that using the calculate function in calculated columns doesn't always work out so well and have since spent entirely too much...
  3. Replies
    3
    Views
    644

    Re: Dynamic Information Table

    Awesome, thank you!
  4. Replies
    3
    Views
    644

    Dynamic Information Table

    Hello,

    Just hoping someone could help point me in the right direction here, as I'm sure I'm going about this problem all wrong.

    I have two data tables, each with transaction data and 3 key...
  5. Replies
    0
    Views
    355

    Disconnected Table Not Detected

    Hello,

    I built a pivot table with several measures that key off a single date, for which I created a disconnected table on a tab in my workbook with one column and a single date value. The purpose...
  6. Re: Average of Averages by Row in Pivot Table

    Awesome, thanks Gary! I'm not sure I've fully grasped it all yet, but the point on data structure makes perfect sense and you've given me what I need to figure it out from here. I can't download the...
  7. Re: Average of Averages by Row in Pivot Table

    Thank you, Gazpage. Let me see if I can explain this a little better.

    My output for this test case at this point looks like the following (will be part of a much more complex table with other...
  8. Re: Average of Averages by Row in Pivot Table

    I ended up solving the issue, although I would say my solution doesn't feel very elegant:

    First, to account for periods with no values in my denominator, I used the following measure to return a...
  9. Re: Average of Averages by Row in Pivot Table

    Thank you, Matt. I'm probably missing something obvious here, but I used sumx to ensure I got the correct grand total at the bottom of the pivot table, and did an offline check to confirm that...
  10. Average of Averages by Row in Pivot Table

    Hello,

    First off, the official disclaimer... I'm new to power pivot, but just finished reading Rob and Avi's book, and have spent the last few weeks learning as much as I can. Apologies if I'm...
  11. Replies
    2
    Views
    617

    Re: Pivot Table Filter - Or Function

    Hi Jerry,

    Thank you for the response. That's kind of what I figured, and already addressed the issue using a solution similar to the one you mentioned. Thought I'd check though to see if I...
  12. Replies
    2
    Views
    617

    Pivot Table Filter - Or Function

    Hello,

    Been poking around on this board and the web for the past hour trying to find out if this is even possible... started to give up, but thought I'd ask the experts first.

    Is there a way to...
  13. Re: Counting unique values in a data table contingent on another field

    Brilliant! Thank you!
  14. Counting unique values in a data table contingent on another field

    Hello,

    I'm trying to figure out which function to nest within the below to allow for counting of unique values in one column, contingent on a value in different column.
    ...
  15. Replies
    0
    Views
    287

    File Distribution using VBA

    Hello,

    I use the following code to break up an excel file into multiple files for distribution. In the files being distributed, I would now like to add a sum function at the end of the last row in...
  16. Replies
    8
    Views
    1,104

    Re: Code pasting values, not formulas

    Got it working now... Thanks to you both for all the help!!!
  17. Replies
    8
    Views
    1,104

    Re: Code pasting values, not formulas

    I'm almost certain I'm missing something really obvious, but my three year old who is sitting next to me desperately wants my attention and I'm struggling to focus...

    That said, I've tried...
  18. Replies
    8
    Views
    1,104

    Re: Code pasting values, not formulas

    Thank you, Tony. I couldn't get that to work though... probably user error, but I keep getting run time errors.
  19. Replies
    8
    Views
    1,104

    Code pasting values, not formulas

    Hello,

    I have the following code set up to break up a single workbook into multiple workbooks for a distribution process. The code works great (thanks to those on this forum who helped me get it...
  20. Replies
    1
    Views
    246

    Sum of Unique Values

    Hello,

    I have a worksheet that has multiple projects assigned to multiple individuals, with overlap between those individuals, and associated sales dollars per project. All of those projects then...
  21. Replies
    4
    Views
    377

    Re: Help writing a Macro

    Thank you!

    The find replace solution works great in all instances save those where there are a large number of email addresses included. In this case I get an error saying the formula is too...
  22. Replies
    4
    Views
    377

    Help writing a Macro

    Hello,

    I have a data table with four fields and approximately 2,500 records that I've been asked to format in a particular manner and I'm struggling with how to do so without writing a macro. The...
  23. Replies
    3
    Views
    269

    Re: Populating Records in a List

    Hi Norrie,

    This is perfect! I don't need code at all... of course, now that I see your response, I remember this solution from a similar situation a long time ago.

    Thanks again! I appreciate...
  24. Replies
    3
    Views
    269

    Populating Records in a List

    Hello,

    I received the following data from my accounting department, and need to fill in the blank records in order to sort, parcel out, and build summary tables off of the original worksheet. Is...
  25. Replies
    6
    Views
    420

    Works perfectly. Thank you so much for your...

    Works perfectly. Thank you so much for your help, Kostas!
Results 1 to 25 of 42
Page 1 of 2 1 2