Pivot Dimension

[Anil_Babu_Samineni]

Hello,

I am trying to take calculated dimension with exclude values

LOAD * Inline [

  P_Des

  All Plants

  Battice

  Birkeland

  EPAD/Brussels

  GOA

  EPAD

];

Here,

1) I want to exclude All Plants & EPAD

2) Is it possible to move that Total values into Right part with last column. This is Pivot Table only.

- ANIL

[sunny_talwar]

1) I would use set analysis within your expression for exclusion

{<P_Des -= {'All Plants', 'EPAD'}>}

2) Do you want to see the total on the right side?

[Anil_Babu_Samineni]

Sunny,

1) P_Des is the Dimension. If i apply this on Dimension getting garbage error

2) Yes

[varshavig12]

Try this:

1. if(P_Des<>'All Plants' or P_Des<>'EPAD', P_Des)

[varshavig12]

2.) Not sure, but may be you are searching for this:

[qlikview979]

Hi Varsha ,

He want total on right side of the table.

Regards

[varshavig12]

Yeah, but he has drag his dimension horizontally.

Hence, thought so!

[Anil_Babu_Samineni]

If i try this, I don't know one more dimension is added, Like below

First field remover, But, I dont have last value which i tick the Yellow

[qlikview979]

Hi Anil,

I hope ,may be this is help full to you?

How to get right total in Pivot table?

[vinieme12]

or even this

          =if(Wildmatch(P_Des,'All Plants','EPAD')=0,P_Des)