Calculating variance in columns pivot table fields

%3CLINGO-SUB%20id%3D%22lingo-sub-2897050%22%20slang%3D%22en-US%22%3ECalculating%20variance%20in%20columns%20pivot%20table%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2897050%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20not%20sure%20if%20this%20can%20be%20done%20or%20not%2C%20i%20have%20searched%20quite%20a%20bit%20for%20a%20solution.%3C%2FP%3E%3CP%3EI%20want%20to%20calculate%20a%20variance%20between%202%20columns%20of%20the%20same%20data%20for%20different%20periods%20in%20my%20pivot%20table.%26nbsp%3B%20I%20am%20trying%20to%20calculate%20the%20variance%20between%202021%20sales%20and%202020%20sales%20inside%20the%20pivot%20table.%20in%20Office%202013%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Cmulhern_0-1635444838170.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F320959iDC6FC06DCF228F57%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Cmulhern_0-1635444838170.png%22%20alt%3D%22Cmulhern_0-1635444838170.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Cmulhern_1-1635444854464.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F320960iC85D2259DCDD7534%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Cmulhern_1-1635444854464.png%22%20alt%3D%22Cmulhern_1-1635444854464.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2897050%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am not sure if this can be done or not, i have searched quite a bit for a solution.

I want to calculate a variance between 2 columns of the same data for different periods in my pivot table.  I am trying to calculate the variance between 2021 sales and 2020 sales inside the pivot table. in Office 2013

 

Cmulhern_0-1635444838170.png  

Cmulhern_1-1635444854464.png

 

 

1 Reply

@Cmulhern 

For Office 2013 that's if add data to data model; install Power Pivot add-in and add explicit DAX measures which calculate Sales, Sales for same period previous year and their difference, when create PivotTable taking data model as the source.

 

Just an idea, ready to use pattern very depends on concrete data plus 2013 is bit old, it may be compatibility issues if create in later version.