4 Replies Latest reply on Dec 10, 2017 2:36 AM by sara abuzeid

    How Make stacked bar chart to be viewed in one bar without marks of stack and return summary for involved data in other

    sara abuzeid

      Hi All,

      your kind support is highly appreciated

      TQ.jpg

      in the above screen shot i have  5 product line for each one i determine top 5 brand name quantity per each product line using index() function , but also i want to add other brands non in top 5 and i did it also

      but the main problem here to make OTHER Brand category to be one bar like the top 5 and when i hoover on it to return the sum of total quantity for all brands  involved in the other category

      but i couldn't collapse them or whatever meaning for it