Show in a pivot table Items that they meet dynamic Sales critirio

[steliosg]

Hi,

How can I show in a pivot table only those items that they made,for example 50% of total turnover.

I'm going to have one dimension,ItemCode and two expressions,sum(Sales),sum(Qty).

Any suggestions;

[#2]

Hi,

see the attached example.

Good luck!

Rainer

[steliosg]

Hello Rainer,

Thank you for your coresponse.

You gave me a direction but what I need is to show the Weeks that contribute the 50% of turnover and and not the Weeks that are up of the 50%

If you have any ideas please send them.

Stelios

[#4]

Hi Stelios,

next round!

Rainer

[steliosg · Accepted solution]

Thank you Rainer.

That was exactly what I want!