As per my question on YouTube, where you suggested i re-ask in this forum and supply test data: I need to calculate a field in my Pivot Table that is in Column I and is calculated as Column H divided by the Grand Total of Column C.
I also have values in Column A that don't necessarily have values for my different filters and would like to maintain row positions but can't quite recall how you did that.
Thank you in anticipation. Best regards, Vanessa
Hi Vanessa,
Welcome to our forum. Thanks for sharing your file. You'll see in the attached file I've added your ReportOutput data to Power Pivot. I've also created some new measures, including one to calculate the 'variance bid magnitude', which you'll see in the PivotTable in columns M:P.
I hope that gives you some indication of how useful Power Pivot can be. If you'd like to learn it, please consider my Power Pivot course.
Mynda
