Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
while Using the rank function in a straight table. I had taken 3 fields productID, Product Name, and in expression count(Product ID) as Total Products and rank column also in expressions. but i was reloaded successful, and the result is same excatly what i expected , so one more column i added Month the result is showing that some fields are null. the data and the application is attached below
Hi,
Here it is showing for only April month,
can you please share the sample app.
okay definitely
try this expression
rank(total count(ProductID)/Count(TOTAL ProductID),0,1)
yeah its working but if we click on anything it is not showing the rank in serial. can you please help me
So if you select any product or month, then % & Rank which is calculated should not change?
suppose if we want to check the top 10 by rank wise if we click on anything % should not be changed and the rank should be change by top 10 wise . Then what i have to do? can you please say
I didn't get this. Can you give one example?
Try below
=AGGR(rank(total count({1}ProductID)/Count({1}TOTAL ProductID),0,1),ProductID)
suppose i want to check top 10 ranks in a year 2008.