Power Pivot Variance Column

  • Thread starter Thread starter mtatlow
  • Start date Start date
M

mtatlow

How do I get the difference between two columns. I want to calculate a variance column (Current Period)-(Prior Period) The periods column headers are not dates, but p01....p12. etc. for the current year and p01Y....p12Y for the prior year"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Variance 2
Pivot Table Subtotals/Variance Analysis 1
Pivot table and variance calculation 1
calculating variances in pivot tables 3
Pivot Table % Variances 0
Adding Columns if Criteria Met 1
Pivot Tables - Variance and Variance % 2
Pivot table column creation: Mission Impossible ? 7

Back
Top