SOLVED

Price before discount

%3CLINGO-SUB%20id%3D%22lingo-sub-2386274%22%20slang%3D%22en-US%22%3EPrice%20before%20discount%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2386274%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20know%20the%20price%20of%20laps%20before%20discount.%26nbsp%3B%3C%2FP%3E%3CP%3Ekeep%20in%20mind%20the%20discount%20is%20fixed%2030%20pounds%20on%20the%20total%20of%20the%20receipt.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20putting%20sample.%3C%2FP%3E%3CP%3ESheet%202%20contains%20completed%20sample%20as%20I%20was%20having%20the%20price%20before%20and%20after%20for%20this%20case.%26nbsp%3B%3C%2FP%3E%3CP%3Esheet%201%20contains%20the%20reset.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2386274%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%3CLINGO-SUB%20id%3D%22lingo-sub-2386401%22%20slang%3D%22en-US%22%3ERe%3A%20Price%20before%20discount%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2386401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F989570%22%20target%3D%22_blank%22%3E%40MarinaSaadalla%3C%2FA%3E%26nbsp%3BSome%20rounding%20variances%20are%20inevitable%2C%20but%20you%20would%20have%20to%20use%20a%20formula%20as%20shown%20in%20the%20picture.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-05-26%20at%2010.27.07.png%22%20style%3D%22width%3A%20557px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283807iAC25C798B453DB46%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-05-26%20at%2010.27.07.png%22%20alt%3D%22Screenshot%202021-05-26%20at%2010.27.07.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20key%20here%20is%20that%20you%20fix%20the%20reference%2C%20(i.e.%20make%20it%20absolute)%20to%20the%20Total%20Price%20before%20Discount%20(in%20this%20case%2C%20B12)%20by%20using%20the%20%24%20sign%20in%20front%20of%20the%20column%20and%20row%20reference.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2397972%22%20slang%3D%22en-US%22%3ERe%3A%20Price%20before%20discount%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2397972%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%20thank%20you%20with%20the%20equation%20it%20really%20helped%20me.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20facing%20another%20problem%20with%20finding%20the%20search%20criteria%20in%20the%20pivot%20table%20%E2%80%A6.%20hope%20you%20can%20help%20me%20with%20it.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20make%20the%20search%20criteria%20to%20be%20highlighted%20in%20my%20pivot%20but%20it%20failed%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2398006%22%20slang%3D%22en-US%22%3ERe%3A%20Price%20before%20discount%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2398006%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F989570%22%20target%3D%22_blank%22%3E%40MarinaSaadalla%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOops%2C%20I%20found%20no%20one%20PivotTable%20in%20the%20sample%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I am trying to know the price of laps before discount. 

keep in mind the discount is fixed 30 pounds on the total of the receipt. 

I'm putting sample.

Sheet 2 contains completed sample as I was having the price before and after for this case. 

sheet 1 contains the reset.  

4 Replies
best response confirmed by MarinaSaadalla (Occasional Contributor)
Solution

@MarinaSaadalla Some rounding variances are inevitable, but you would have to use a formula as shown in the picture.

Screenshot 2021-05-26 at 10.27.07.png

The key here is that you fix the reference, (i.e. make it absolute) to the Total Price before Discount (in this case, B12) by using the $ sign in front of the column and row reference.

@Riny_van_Eekelen  thank you with the equation it really helped me. 

I'm facing another problem with finding the search criteria in the pivot table …. hope you can help me with it. 

I'm trying to make the search criteria to be highlighted in my pivot but it failed   

@MarinaSaadalla 

Oops, I found no one PivotTable in the sample

Hi @Sergei Baklan the sheet named with pivot table data is el column I want to compare the search criteria with ... I couldn't put all the pivot table as the data is confidential.

Hope you can help me to search with the criteria in the pivot table data and find the the duplication colored.