Unexpected expression result in Pivot Table

[nagarjuna_kotha]

Hi i have a one requirement using Pivot table.In that i m facing one issue i m not getting TOTAl on one colum,what should i do ,tell me some valid solutions.i m sharing expressions cheak it where i m doing wrong,PLzzz Give ASAP

1.

=(Num(Sum(Total<REGIONNAME,BRANCHNAME,DEALERNAME,DIVISIONNAME> Aggr(

IF( Window_Id=2,

  sum({<RTESACall_247={'Within4HR'},Tier={'Metro','Tier 2','Tier 3 and Above','Undefined'}>}TotalRTCall),

)

, REGIONNAME,

  BRANCHNAME,

  DIVISIONNAME,

  DEALERNAME,

  Tier

  ))

,vFWNumberFormat

))/(Num(

  SUM(Total<REGIONNAME,BRANCHNAME,DEALERNAME,DIVISIONNAME> TotalRTCall)

  ,vFWNumberFormat

  ))

2.

= if(Count(DIVISIONNAME)>0 and DealerCategory='A','90',

if(Count(DIVISIONNAME)>0 and DealerCategory='B','85',

if(Count(DIVISIONNAME)>0 and DealerCategory='C','80')))& ' '& '%'

//=if(not IsNull(DIVISIONNAME),$(vCost))

3.

(Num(Sum(Total<REGIONNAME,BRANCHNAME,DEALERNAME,DIVISIONNAME> Aggr(

IF(Window_Id=2,

  sum({<TATESACall_247={'Within48HR'},Tier={'Metro','Tier 2','Tier 3 and Above','Undefined'} >}TotalDTCall),

  )

,

  REGIONNAME,

  BRANCHNAME,

  DEALERNAME,

  DIVISIONNAME,

  Tier

)),vFWNumberFormat

))/(Num(

  SUM(Total<REGIONNAME,BRANCHNAME,DEALERNAME,DIVISIONNAME> TotalCall)

  ,vFWNumberFormat

  ))

4.

= if(Count(DIVISIONNAME)>0 and DealerCategory='A','80',

if(Count(DIVISIONNAME)>0 and DealerCategory='B','75',

if(Count(DIVISIONNAME)>0 and DealerCategory='C','70')))& ' '& '%'

5.

=Count({<STATUS_ID= {1014,1015,2061},CALL_CATEGORY={'PMS'}

  >}DISTINCT(TICKET_ID))/Count({<CALL_CATEGORY={'PMS'}>}DISTINCT(TICKET_ID))

6.

= if(Count(DIVISIONNAME)>0 and DealerCategory='A','98',

if(Count(DIVISIONNAME)>0 and DealerCategory='B','95',

if(Count(DIVISIONNAME)>0 and DealerCategory='C','93')))& ' '& '%'

7.

=sum({<Division={'50','51','52','53','54','55','56','57'}>}BillAmount)

8.

=if(DealerCategory='A',150000,

if(DealerCategory='B',100000,

if(DealerCategory='C',75000))

)

9.

=sum(PAYOUT_RATE)

10.

Bonus% :

=if(DealerCategory='A' and Column(1)>='90%' and Column(3)>='80%' and Column(5)>='98%' and Column(7)>='150000',10,

if(DealerCategory='B' and Column(1)>='85%' and Column(3)>='75%' and Column(5)>='95%' and Column(7)>='100000',5,

if(DealerCategory='C' and Column(1)>='80%' and Column(3)>='70%' and Column(5)>='93%' and Column(7)>='75000',1,0)))&'%'

Bonus :

=Num((sum(PAYOUT_RATE))*Column(10))

Urgent>>>>>>>>>>>>>>>>>>>>>>.

Thanks in Advance

[tamilarasu]

Nagarjuna:  Is it possible to upload the file.?

[nagarjuna_kotha]

No

[PrashantSangle]

Hi,

What do you expect in Total Column??

It is sum or Avg of column

Use appropriate function in expression

try like

sum(

if(DealerCategory='A' and Column(1)>='90%' and Column(3)>='80%' and Column(5)>='98%' and Column(7)>='150000',10,

if(DealerCategory='B' and Column(1)>='85%' and Column(3)>='75%' and Column(5)>='95%' and Column(7)>='100000',5,

if(DealerCategory='C' and Column(1)>='80%' and Column(3)>='70%' and Column(5)>='93%' and Column(7)>='75000',1,0)))

)&'%'

Regards

[ToniKautto]

I have changed the subject of this thread to better describe your question. There is no urgency parameter in the community, so to get best possible attention and feedback it is important to provide a accurate subject and appropriate level of details to enable community member to understand your problem and scenario.

- A chart is calculated based on the fields used in dimensions and expressions.

- The required data from these fields will be extracted to enable the aggregation

- The relation of the fields in your data model determine how the data in the fields will be joined together

- A problem is typically defined by a observed result and a expected result

Please clarify who you think we are supposed to understand your data model, chart setup, expected result and observed result based on a list of expressions if you are not able to provide a sample file?