user034162

Thanks a lot! I will try the way you recommend!

Thanks for @GrantSmith answer. I'd like to provide a detailed example to explain my question. Usually, the category2 that belongs to 6month in category1 would get fewer deals than category2 in the other two category1. So I could not rank within category1. I give an example in the excel table chart, but I want to create a…

Thanks so much! I will try this way.

@jaeW_at_Onyx Thanks for your help. I followed your instructions and everything is good before I limited rows. I had a 13-month data in the pivot table in Domo with setting category as the x-axis and reporting date as the y-axis. After I limit rows to 30 (I have 4-5K rows originally), the table only shows the data in the…