I have a classic bar chart showing Product Category in axis X and sum(SELLING_PRICE) in axis Y ordered by Y-Value descending.
I need to divide this chart in 3: Top Performing, Mid Performing, Bottom Performing depending by Y-Value.
My unique selection is Period because in each period I don't sell same PRODUCT_CATEGORY and I need to show only PRODUCT_CATEGORY sold in selected Period.
My Idea is making 3 charts , the first with Top N , the 3th with Bottom M , the 2nd with Medium P Product Category performer.