Percentage split in pivot

[pranali_gawde]

Hi sir,

I am trying to calculate percentage in pivot but after adding month as column that percentage divide into two months.if i selected only one month then it is cming correct.can u plz help me to resolve this issue.

Below is the snapshot and expression for the same.

This is one month:

Two Month

Expression:

Sum(Aggr(sum(DISTINCT{<Flag={'SJ'},fMonth=,[SEGMENT_CODE]={'1','6'}>}TEU),ECARRIER_NAME,Fcldata))

/Sum(total Aggr(sum(DISTINCT  {<Flag={'SJ'},fMonth=,[SEGMENT_CODE]={'1','6'},ECARRIER_NAME={'*'}>}  TEU), Fcldata))

[rubenmarin]

Hi Pranali, TOTAL is used to ignore dimensions (month dimension is also ignored), if you want to keep some dimensions you can add the fields between <>:

Sum(Aggr(sum(DISTINCT{<Flag={'SJ'},fMonth=,[SEGMENT_CODE]={'1','6'}>}TEU),ECARRIER_NAME,Fcldata))

/Sum(total <Month> Aggr(sum(DISTINCT  {<Flag={'SJ'},fMonth=,[SEGMENT_CODE]={'1','6'},ECARRIER_NAME={'*'}>}  TEU), Fcldata))

[pranali_gawde]

Grate,It's working fine.

Thank you so much sir.