This content has been marked as final. Show 4 replies
iwant to display region wise top five customers sales and rest of other customer sales with label "Others", when i writen rank with aggr in pivot table its giving wrong no. of customers and sales value.
please give a solution.
for your reference i attached the file, in that file contains 2 table green table is containing the requirement and blue table contans data for validation
Thanks in advance