Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use this Expression
Aggr(Count(Customer),Sales_Group)
You will get count of customers accordning to Sales_Group wise.
Hope it helps
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?