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

[qlikview979]

Hi,

Pivot table - Total on the right side using formula

[trdandamudi]

The reason one more dimension is poping up because of nulls, check "Suppress When value is Null" in the dimension tab and that will take care of it.

[Anil_Babu_Samineni]

Yes, That is one way. But, i already check that. Anyway, The 0 showing Field not the value.

[Anil_Babu_Samineni]

Nothing change, Same as Varsha expression only

[Anil_Babu_Samineni]

Yes, I am changing the dimension from vertical to Horizontal , In this the total is not moved to right side?

[sunny_talwar]

Need to apply this to the expression.... Assuming you have Sum(Sales), change it to this:

Sum({<P_Des -= {'All Plants', 'EPAD'}>}Sales)

[Anil_Babu_Samineni]

I already check these two threads. But, First link is not useful for me. But, Second link showing similar to me. But i didn't understand this ?

[Anonymous]

You should read those thread entirely, with the IMAGES attached, then you will get to know..

[vinieme12]

Can you post the sample?

[sunny_talwar]

Anil -

I would recommend avoiding calculated dimensions as much as possible. Your scenario is fairly simple which can be handled very easily using set analysis. If you can share your expression, we can propose where you need to add the set analysis I provided above.

Best,

Sunny