Forum Discussion
Donut Chart / pie chart
I resolved it.
Created two measures, one which give value for 5 products and other which gives value for rest products and added it to the donut chart.
Hi Anonymous ,
When you put your fields in the donut chart (Product under "Legend" and Value under "Values"), under the Filters tab -> Visual Level Filters, click on the dropdown arrow for "Product", change the filter type from "Basic filtering" to "Top N". There, you can choose to display Top X number of products you want.
I know about the visual level filters and selecting top 5 products. But this is not what i want.
your solution will display the top 5 products in the donut chart.
As i mentioned,
within the Donut chart, there should be two displays,
one --> shows the total of top 5 products
other --> shows total of rest products
please let me know if this can be implemented
Hi Anonymous
Sorry I misread your question.
What you can do is:
- Create the donut chart
- Since the donut chart is sorted descending, on your keyboard, hit and hold Ctrl. Select the top 5 products in the donut chart (in this case the top 5 that takes up the most space).
- Once all 5 are selected, right click on it, and click Group.
Once you've done that, it will group the top 5 as one category, and the others as another category.
I dont think that is the solution.
This is because the top 5 products may change based on the inventory values, and if you are grouping on specific products that gives the wrong value on the donut chart