How to calcuate count of product based on condition

[aniketsr]

Hi Everyone,

I have a small question

How can I calculate the count of products who have contributed to the 99% of net sales.

Any guidance will be appreciated.

[settu_periasamy]

Hi,

May be you try with Dimension Limit. Check the below snap shot..

[aniketsr]

HI Settu,

I cannot use the dimension limit functionality,as I have brand and category in the dimension .

please hekp me out with the necessary expression.

[settu_periasamy]

I think that won't be a problem. It will display % (relative to the total) of your expression.

Did you try it? If not working, Can you just post a sample qvw?

[aniketsr]

yes I tried it as I don't have product in the dimension it is sowing wrong numbers.

Secondly, the above setting will give product which contribute to the 99% of net sales, but I need the count of products which contribute to the 99% of net sales.

[settu_periasamy]

Can you provide the sample and expected output?

[swuehl]

It's unfortunately not straight forward to calulcate the count of products, but may my answer here will give you some possible solutions / work around:

Re: Identify count of vendors based on spend

You can also have a look at the discussion below this blog post for ideas how to do the count in QV in straight forward way (unsupported right now):

The sortable Aggr function is finally here!