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

Per cent in pivot table

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)

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

• Re: Per cent in pivot table

For your P.S: query the discussion behind this link might help. http://community.qlik.com/message/272874#272874

Jonathan

• Re: Per cent in pivot table

I don't quite understand what you want, but have a look at the attached qvw. Is that what you need?

• Re: Per cent in pivot table

Thank you. Table1 works fine. I made one mistake, I had to just remove 1 from Sum({1<MustSKUList={'In'}>}Sales)

Regards, Stark