Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
And maybe an option to answer question 3
Attached suggested solutions for the first two questions.
And maybe an option to answer question 3
Your Answer is as expected Thank you so much.
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