How to include column with PowerPivot RELATED function in PivotTable

[Laurie L]

For those of you who are using PowerPivot, I have a table with a column containing a RELATED function. I want to include that column in my PivotTable, however, when I view the "Table Properties" that column is not available to add to the PivotTable field list. How can I make this happen?

 

[SirJB7]

Hi, Laurie L!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you, relieving the contributor of having to build a test file, if necessary. Thank you.

Regards!

 

[Debraj]

Hi Laurie,

Welcome to the forum..

I think, we still don't have option include DAX formula's in normal PivotTable..

PS: From the SQL point of view, any alias is not accessible, until its executed, so I just only can say.. column created by RELATED formula, is run time created column..

Still crossing finger, on the meanwhile, check this post..
http://www.powerpivotpro.com/2009/11/dax-the-related-function/