Hello,
I need your help that couldn't handle. I have a table displaying seller names. I built up a formula in the same table showing sellers to success, not success, success-late, and pending (same sellers' names exist but product is the same). When I created a Pivot Table, I want to also display different percentages of seller. For instance, normally a seller who sold 6 items give me %100. Because what target is determined by selling number. However, some sellers sold items after deadline (success-late), but the same seller sold another item successfully (success), and one item is still pending.
I want to create a slicer in order to display different percentages. For example, Seller X's success rate must be divided to its successfully item's to success-late plus pending.
How can I overcome this. I know Pivot Table restricts some multiple calculations because my formula in the same column of the table.
Thanks in advance.