locked
Disappearing Calculated Column RRS feed

  • Question

  • I had a PowerPivot (Excel 2013) calculated column called 'Revenue'

    The calculation was a sumx formula to pull revenue from a different table bassed on an ID

    I have a different calculated column based on 'Revenue' called 'Revenue Impact'

    'Revenue' is no longer visible.  I don't know what happened to it.  I don't see it in Diagram View, I don't see it in the Filed List when i'm working with the Pivot within Excel window.  It's as if the column was deleted.  The strange thing is that the other calculated column, 'Revenue Impact', which is based on 'Revenue', is still there, and it returns the correct results.  But 'Revenue' is nowhere to be found.  Any thoughts? 

    Another strange thing is that I had a measure in the same column as Revenue.  The measure is still there, but it is now beneath the column that used to be adjacent to 'Revenue'.  I'm so confused.  Is it possible to hide a column within the Data View of PowerPivot?  if so, how do I unhide the column?

    thanks!

    Thursday, June 19, 2014 11:21 PM

Answers

All replies