Forum Discussion

TViljoen's avatar
TViljoen
Regular Visitor
2 years ago

Thanks Ashish_Mathur 

 

This is a great starting point, but When i filter on lets say Violation1 and Violation2:

 

The Other Value becomes 0 - becasue the measure is then only incorporating the Values of those Two Errors - and thus my Error Other becomes 0

 

Is there a Way to Pivot Away from the TopN focus, and more on the Spesific Violations Selected?

 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Ashish_Mathur,

       

      Thank you for the solution, I would like to ask if it is possible to achieve the other way round?

      I want to group the selected values from the slicers as "others" while the unselected will be shown as is instead.

      Desired output:

      1. select cust1 and cust2 from slicer 

      2. In table visual cust1 and cust2 grouped as "other", and cust3 and cust4 show individually 

      Customervalue
      other (cust1+cust2)300 (100+200)
      cust3200
      cust4300

       

      Thank you.

       

      Regards,

      Ronald

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        2 years ago

        You are welcome.  I am not sure.  Furthermore, i cannot understand the business sense in doing so.