Pivot Table Calculation

[#1]

Hi Friends,

Need advice on the below requirement (pivot table) for the attached QVW file.

Q 1. Sum of "Based on Input Values" Column: (I need it in a variable):

Answer (For this given example): 90  

Variable = 3  (This will change dynamically)

Q 2. Rank Column, we need the rank of 'Based on Input Values 'column.If the values are repeating need to give the same rank.

Variable = 3  (This will change dynamically)

Q 3. Need to find the top value from the column 'based on input values'. if the top value has the duplicates then v need to avoid that and have to find the next top value. Then v need to multiply the variable value with that value.

Thanks in Advance,

Pooja

[swuehl]

Attached suggested solutions for the first two questions.

[swuehl · Accepted solution]

And maybe an option to answer question 3

[#4]

Your Answer is as expected Thank you so much.

[#5]

Hi,

Thanks for your Valuable solution but still i need the below changes. and I have attached the updated QVW file

Q1

When i am rounding the total values in the text object i am losing 0.01 from the 'Based on Input Values' column. So here i need to find out the difference in new variable. For this ex: it is 0.01  (It may vary when i am adding data in future).

for Q2

Here the 2nd rank is missing. Though the 1st rank is duplicate i still need to give 2nd rank to the next person.

Regards,

Pooja