So if you use "related" function, does that mess up a pivot that relies on that sheet?

[pete234]

I put some formula in one of the power pivot sheets I have that I also pull into a power pivot table.
There were time stamps so some of the detail records were off and some people just wanted the raw data slightly modified.
So I used RELATED to pull in a couple fields that I usually pull in for summing/counting in the pivot table.
However, the original pivot seemed to blow up the number of records by 50 times, like 5k records became 500k.
I didn't finish reviewing it yesterday but thought somehow this is creating a circular unchecked relationship, similar to what access does if the join is off. So question is can you have a sheet using RELATED and still have that accurately feed a pivot table?

 

[Laurent C]

How and where do you use RELATED? Can you be a little more explicit about that?

 

[pete234]

How and where do you use RELATED? Can you be a little more explicit about that?

Well I tested it yesterday and it did not seem to cause any issues.
I was using it to pull in custom sales team and fiscal periods, that I normally join in the pivot table.
So I left the old pivot data alone instead of bringing in my new RELATED fields (probably my original issue) and it worked the same, plus I could dump the remapped raw data to another file as needed. I like this RELATED, a true VLOOKUP replacement I think. Heck I mapped 98k lines of data with 6 fields using it today, the equivalent of hundreds of thousands of vlookups. Not bad.