Hi friends
I have prepared a expenses schedule in pivot table and attached my document also.
In my table I have filed "TYPE" where F=Fixed V=Variable S=Semi variable
I want to make a calculation of expenditure on the following basis
When I select a percentage say 90% I want the amount to be calculated on the following basis
All Fixed Item should remain unchanged
All variable item should change to 90% of the amount
All semi variable items as per percentage in put by the user
Pls help me to make the calculation
