I have a pivot table which shows my purchase on different dates from different users and different Rates.
purchaseDate
Item
supplies
Rate
Discount
Final Rate
Now I want to calculate difference of "final rate" minus "sale rate" which i will enter manually.
I want to get the difference in simple figure and then in percentage
I want a table when i select an item from drop down list , it show item, date, supplier
best regards.