Pivot Table Problem

[senpradip007]

Hi

Today I need a help from you.

I've a Pivot table named Chart and its property named prop..

I want to count customer with respect to Sales Group and I'm using =Count(Customer) as expression. It shows 36 instead of 4.

Can anyone help me out of this problem?

Thanks in advanced.

[manideep78]

Use this Expression

Aggr(Count(Customer),Sales_Group)

You will get count of customers accordning to Sales_Group wise.

Hope it helps

[senpradip007]

Hi Manideep,

Thanks for reply.

According to your expression, it calculates the right result when I select only one Sales_Group, it calculates nothing when nothing selected or more than one Sales_Group selected..

What can I do?