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

[Anil_Babu_Samineni]

First task is finished.

I am asking you different one

I have one date field with the format of dd.mmm.yyyy hh:mm:ss:ff tt

So here I want to get the weeks in list box. Might be this is possible in calendar only. In that, what I need to take the code.

Lets assume

Load * inline[

Month_date, year_date

1, jan

2, feb

.,

.,

.,

12,dec

];

I want to show one list box with the field of week

1

..... 52

[vinieme12]

Week is already available in the sample i posted, see field name  CAL_Week.

Also as your original query is resolved please close this thread.

[Anil_Babu_Samineni]

Thank you, its working

[Anil_Babu_Samineni]

Vineeth, Sorry for troubling. Can you please have a look of this and let me know how to acheive this