2 Replies Latest reply: Mar 4, 2013 4:17 AM by Pradip Sen

Pivot Table Problem

Pradip Sen Mar 4, 2013 3:44 AM

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.

Re: Pivot Table Problem

Manideep Hv Mar 4, 2013 3:58 AM (in response to Pradip Sen)

Use this Expression

Aggr(Count(Customer),Sales_Group)

You will get count of customers accordning to Sales_Group wise.

Hope it helps
Like Show 0 Likes (0)

Actions
- Re: Pivot Table Problem
  
  Pradip Sen Mar 4, 2013 4:17 AM (in response to Manideep Hv )
  
  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?
  
  Like Show 0 Likes (0)
  
  Actions