# Search:

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

Page 1 of 2 1

1. ## Thread: Calculated Column Circular Error need alternative solution

by ollieotis
Replies
1
Views
499

### 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. ## Thread: Calculated Column Circular Error need alternative solution

by ollieotis
Replies
1
Views
499

### 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. ## Thread: Dynamic Information Table

by ollieotis
Replies
3
Views
642

### Re: Dynamic Information Table

Awesome, thank you!
4. ## Thread: Dynamic Information Table

by ollieotis
Replies
3
Views
642

### 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. ## Thread: Disconnected Table Not Detected

by ollieotis
Replies
0
Views
354

### 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. ## Thread: Average of Averages by Row in Pivot Table

by ollieotis
Replies
8
Views
736

### 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. ## Thread: Average of Averages by Row in Pivot Table

by ollieotis
Replies
8
Views
736

### 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. ## Thread: Average of Averages by Row in Pivot Table

by ollieotis
Replies
8
Views
736

### 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. ## Thread: Average of Averages by Row in Pivot Table

by ollieotis
Replies
8
Views
736

### 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. ## Thread: Average of Averages by Row in Pivot Table

by ollieotis
Replies
8
Views
736

### 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. ## Thread: Pivot Table Filter - Or Function

by ollieotis
Replies
2
Views
609

### 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. ## Thread: Pivot Table Filter - Or Function

by ollieotis
Replies
2
Views
609

### 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. ## Thread: Counting unique values in a data table contingent on another field

by ollieotis
Replies
2
Views
691

### Re: Counting unique values in a data table contingent on another field

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

by ollieotis
Replies
2
Views
691

### 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. ## Thread: File Distribution using VBA

by ollieotis
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. ## Thread: Code pasting values, not formulas

by ollieotis
Replies
8
Views
1,099

### Re: Code pasting values, not formulas

Got it working now... Thanks to you both for all the help!!!
17. ## Thread: Code pasting values, not formulas

by ollieotis
Replies
8
Views
1,099

### 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. ## Thread: Code pasting values, not formulas

by ollieotis
Replies
8
Views
1,099

### 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. ## Thread: Code pasting values, not formulas

by ollieotis
Replies
8
Views
1,099

### 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. ## Thread: Sum of Unique Values

by ollieotis
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. ## Thread: Help writing a Macro

by ollieotis
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. ## Thread: Help writing a Macro

by ollieotis
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. ## Thread: Populating Records in a List

by ollieotis
Replies
3
Views
268

### 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. ## Thread: Populating Records in a List

by ollieotis
Replies
3
Views
268

### 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...