3 Replies Latest reply on Aug 20, 2016 10:15 AM by Adrian Ward

    top 10 and rest others in union report

    3193829

      Hi,

       

      I have a requirement to have Top 10 and rest others in a union Report with their totals(Top 10 total, grand total). I have used the rank on metrics to have the top 10 and rest others (eg case when rank(sales)<=10 then "Customer.Cname" else "Others" end). But i cannot put subtotal on a metric in pivot table. Selection steps is not enabled in the union report.

       

      Is there any way to acheive the top 10 and rest others in a union report ?

       

      Thanks

      Kalpana