3 Replies Latest reply: Oct 26, 2012 7:57 AM by S S RSS

    Per cent in pivot table

    S S

      Hello,

      Can you help me with my problem? Please, see attached file.

      The Table1 shows sales all categories per store, sales only categories in must SKU list per store, per cent of supplier's sales in all sales per store and per cent of supplier's sales in must SKU sales per store. My problem is this: if I want to see sales only one supplier in every store (I select it from listbox), column "MustSKUList" shows me excluded suppliers too. I use the such formula Sum({1<MustSKUList={'In'}>}Sales)

       

      Thanks for your help, Stark

       

      P.S. It would be very wonderful, if per cent of supplier's sales in all sales per store and per cent of supplier's sales in must SKU sales per store were culculated in one column. I try to use sum(Sales)/sum({1}TOTAL<Store> Sales), but it works wrong, It divides supplier's MustSkuList sales on total sales of store