Exp Sch

[upaliwije]

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

[#2]

Hi,

Please see the attached solution.

Is this what you are looking for?

A