Restricting Data as per User Input

[deepakk]

Hi All,

I need to restrict the data as per user Input. For Eg if the user enter 5000 the total value in the pivot table sholud not increase more than 5000 and also it should the mxa price first.

Input : 5000

Actual Data

Product Price Amt

A 30 3000

B 40 2000

C 10 4000

B 20 2000

Output Should Be:

Product Price Amt

B 40 2000

A 30 3000

total = 5000

Thanks & REgards

Deepak