A user requested today that they want to see products which have a top n% and show the others as a % total. Currently when we use the % share and others together we have this:
As you can see, row one (which was 70%) is now showing 100% (understand as its one row, so it would naturally show 100%), but if in Percentage share format, the user was expecting 70% and the “others” column to be 30% not the actual value, this is what we were expecting:
Can % share please have the ability to show the percentage in “others” instead of the value?
In addition, the end user also wanted in a separate column to see the value, So Ideally the grid wanted to appear as below (I cannot see how this can be achieved in custom mode or database design either as its dynamic based on dimension selection):
Note: For clarity, Column1 is percentage share, Column2 is actual sales value in $
Finally, the absence of criteria to apply to % share. If I wanted to filter on anything above 65%, this is not possible either, as below there is no % share option in the format of the advanced search.
Please can the above be introduced? If there are any workarounds I would appreciate them.