I am attaching the Raw Data, QVW and a Text file for reference. Please help me to find out the solution.
I want a Line Chart for
Dimensions - Class & Occuerence
Expression - Final Amount
Error is - when I enter 1000 in user input box, I get nearest Max 1000.3 and Nearest Min as 999 so while pulling this on Line Chart 1000.33 goes to Unknown Class and 999 comes under 1000 which is true because the cosndition specified is alike.
But, I want the FInal Calculations which is based on the Interpolation formula to be displayed on Class 1000 in Line CHart.